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

select sid,sname from Student
where sid not in (
    select sid from SC
    where cid=(
        select cid from Course
        where tid=(
        select tid from Teacher
            where  tname='张三'
        )
              )
    );

Student表：

SC表：

Teacher表:

Course表：