(１)mysql> select name,gender,birthday,salary from employee
    ->  where gender='女'
    ->  and(birthday>='1990-01-01' or name='システム開発部');
+----------+--------+------------+--------+
| name     | gender | birthday   | salary |
+----------+--------+------------+--------+
| 鈴木花子 | 女     | 1990-02-11 | 250000 |
+----------+--------+------------+--------+
1 row in set (0.01 sec)


(２)mysql>  select name,floor from department
    -> where name='総務部'
    -> or (name='システム開発部');
+----------------+-------+
| name           | floor |
+----------------+-------+
| 総務部         |     8 |
| システム開発部 |    12 |
+----------------+-------+
2 rows in set (0.10 sec)


(３)mysql> select name,gender,birthday,salary from employee
    -> where name like '%良%';
+----------+--------+------------+--------+
| name     | gender | birthday   | salary |
+----------+--------+------------+--------+
| 高橋良子 | 女     | 1985-11-23 | 300000 |
| 鈴木良枝 | 女     | 1970-05-03 | 450000 |
+----------+--------+------------+--------+
2 rows in set (0.00 sec)


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