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

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