day05

SELECT * FROM student WHERE SId in
(
select sid from sc where sid<>'01' group by sid -- 取出不是01学生的cid 并排序 和 取出01学生的cid并排序 进行比较
having group_concat(cid ORDER BY cid) = (select group_concat(cid ORDER BY cid) from sc where sid = '01')
)

SELECT Sname FROM student WHERE SId NOT IN (
    SELECT SId FROM sc WHERE CId IN (
        SELECT CId FROM course WHERE TId IN (
            SELECT TId FROM teacher WHERE Tname = '张三'
        )
    )
)