– 8、查询没学过"张三"老师授课的同学的信息
SELECT st.*
FROM student st
WHERE st.s_id NOT IN
(SELECT sc.s_id FROM score sc WHERE sc.c_id IN
(SELECT c.c_id FROM course c,teacher t WHERE c.t_id=t.t_id AND t.t_name='张三'))
– 8、查询没学过"张三"老师授课的同学的信息
SELECT st.*
FROM student st
WHERE st.s_id NOT IN
(SELECT sc.s_id FROM score sc WHERE sc.c_id IN
(SELECT c.c_id FROM course c,teacher t WHERE c.t_id=t.t_id AND t.t_name='张三'))