mysql> use practice;
Database changed


(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 |
| 高橋良子     | 女     | 1985-11-23 | 300000 |
| 鈴木良枝     | 女     | 1970-05-03 | 450000 |
+--------------+--------+------------+--------+
3 rows in set (0.07 sec)


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


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


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


mysql>