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.10 sec) mysql> SELECT dep_id, name FROM Department -> WHERE name IN ('総務部', 'システム開発部'); +--------+----------------+ | dep_id | name | +--------+----------------+ | D001 | 総務部 | | D003 | システム開発部 | +--------+----------------+ 2 rows in set (0.07 sec) mysql> SELECT name FROM Employee WHERE name LIKE '%良%'; +----------+ | name | +----------+ | 田中良子 | | 鈴木良枝 | +----------+ 2 rows in set (0.00 sec) mysql> SELECT name FROM Department WHERE name LIKE '_務_'; +--------+ | name | +--------+ | 総務部 | +--------+ 1 row in set (0.00 sec)