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

建表语句点击详见

– 查询没学过"张三"老师讲授的任一门课程的学生姓名

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