-- 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、查询没学过“张三”老师课的学生的学号、姓名(重点)
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</