SQL面试50题-13

13.查询没学过"张三"老师讲授的任一门课程的学生姓名 和47题一样（重点，能做出来）
思路
关联字段： teacher.t_id 、
course.t_id 、course.c_id
score.c_id 、score.s_id
student.s_id
1.查询张三老师讲授的课程
SELECT c_id FROM Course WHERE t_id = '01'
2.查询张三老师的id
SELECT t_id FROM Teacher WHERE t_name = '张三'
完整代码

    SELECT s_id,s_name FROM Student WHERE s_id NOT IN 
        (SELECT s_id FROM Score WHERE c_id IN  
            (SELECT c_id FROM Course WHERE t_id = 
                (SELECT t_id FROM Teacher WHERE t_name = '张三')));