-- 5、查询没学过“张三”老师课的学生的学号、姓名(重点)
SELECT s_id,s_name FROM student
WHERE s_id NOT IN (
SELECT s_id FROM score
WHERE c_id=(
SELECT c_id FROM course
WHERE t_id=(
SELECT t_id
FROM teacher
WHERE</
5、查询没学过“张三”老师课的学生的学号、姓名(重点)
最新推荐文章于 2022-10-28 00:37:05 发布