mysql> use practice;
Database changed

mysql> select name, gender,birthday, salary,dep_id  from employee
    -> where gender = '女'
    -> and(birthday>='1990-01-01' or dep_id='D003');
+--------------+--------+------------+--------+--------+
| name         | gender | birthday   | salary | dep_id |
+--------------+--------+------------+--------+--------+
| 鈴木花子     | 女     | 1990-02-11 | 250000 | D002   |
| 高橋良子     | 女     | 1985-11-23 | 300000 | D003   |
| 鈴木良枝     | 女     | 1970-05-03 | 450000 | D003   |
+--------------+--------+------------+--------+--------+
3 rows in set (0.00 sec)

mysql> select name,dep_id from department
    -> where name in ('総務部','システム開発部');
+-----------------------+--------+
| name                  | dep_id |
+-----------------------+--------+
| 総務部                | D001   |
| システム開発部        | D003   |
+-----------------------+--------+
2 rows in set (0.01 sec)

mysql> select name from employee
    -> where name like '%良%';
+--------------+
| name         |
+--------------+
| 高橋良子     |
| 鈴木良枝     |
+--------------+
2 rows in set (0.01 sec)

mysql> select name from department
    -> where name like '_務_';
+-----------+
| name      |
+-----------+
| 総務部    |
+-----------+
1 row in set (0.00 sec)