(1)
mysql> select name,gender,birthday,salary from employee where gender = '女'
    -> and( birthday >= '1990-01-01' or dep_id = ' D003');
+----------+--------+------------+--------+
| name     | gender | birthday   | salary |
+----------+--------+------------+--------+
| 鈴木花子 | 女     | 1990-02-11 | 250000 |
+----------+--------+------------+--------+
1 row in set (0.01 sec)

(2)
mysql> select dep_id,name from department where name = '総務部' or name = 'システム開発部' ;
+--------+----------------+
| dep_id | name           |
+--------+----------------+
| D001   | 総務部         |
| D003   | システム開発部 |
+--------+----------------+
2 rows in set (0.08 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)