有趣的sql语句，留作记录

S(sno,sname,sex)，
SC(sno,cno,grade)， C(cno,cname,)。
查询至少和张三选课一样的学生学号

CREATE TABLE S
(
	sno int,
	sname varchar(10),
	sex varchar(2)
)
CREATE TABLE sc
(
    sno int,
    cno int,
    grade varchar(10)
)
CREATE TABLE c
(
    cno int,
    cname varchar(10)
)

SELECT 
*
FROM s AS a
WHERE NOT EXISTS(SELECT 1 FROM s AS b INNER JOIN SC AS c ON c.sno=b.sno WHERE sname='张三' and NOT EXISTS( SELECT 1 FROM sc WHERE sno=a.sno AND cno=c.cno))