– 8、查询没学过“张三“老师授课的同学的信息

– 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='张三'))