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

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

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

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