-- 14、查询没学过“张三“老师讲授的任一门课程的学生姓名

SELECT st.s_name 
FROM student st 
WHERE st.s_id 
NOT IN (
SELECT sc.s_id
FROM score sc 
INNER JOIN course c ON c.c_id=sc.c_id
INNER JOIN teacher t ON t.t_id=c.t_id AND t.t_name="张三"
)