2020/11/22 刘一辰的JAVA随笔

今日目标：Mysql学习26

实验内容：

-- 21.查询 张旭 教师任课的学生的成绩

select * from student where s_no IN (SELECT s_no FROM score WHERE c_no = (SELECT c_no FROM course WHERE t_no = (SELECT t_no FROM teacher WHERE t_name='张旭')));

 

+------+--------+-------+---------------------+---------+

| s_no | s_name | s_sex | s_birthday          | s_class |

+------+--------+-------+---------------------+---------+

| 103  | 王丽   | 女    | 1976-01-23 00:00:00 | 95033   |

| 105  | 王芳   | 女    | 1975-02-10 00:00:00 | 95031   |

| 109  | 赵铁柱 | 男    | 1974-06-03 00:00:00 | 95031   |

+------+--------+-------+---------------------+---------+