5.查询没学过“张三”老师课的同学的学号、姓名

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表：