数据查询|数据库（3.3）

SELECT Sname FROM Student WHERE Sno IN (SELECT Sno FROM SC WHERE Cno=2);

SELECT Sno,Cno FROM SC X WHERE Grade >= (SELECT AVG(Grade) FROM SC Y WHERE Y.Sno=X.Sno)

SELECT Sname FROM Student WHERE Sdept<>'CS' AND Sage < ALL(SELECT Sage FROM Student WHERE Sdept='CS');

SELECT Sname FROM Student WHERE Sdept<>'CS' AND Sage < (SELECT MIN(Sage) FROM Student WHERE Sdept='CS');

SELECT Sname FROM Student X,SC WHERE X.Sno=SC.Sno AND Cno=2;

SELECT Sname FROM Student WHERE Sno IN (SELECT Sno FROM SC WHERE Cno=2);

SELECT Sname FROM Student X WHERE EXISTS (SELECT * FROM SC WHERE Sno=X.sno AND Cno=2);

--理解为不存在（存在一门课没有选）
SELECT Sname FROM Student X WHERE NOT EXISTS (SELECT * FROM Course Y WHERE NOT EXISTS (SELECT * FROM SC WHERE  Y.Cno = Cno AND X.Sno = Sno )) ;

SELECT DISTINCT Sno FROM SC X WHERE NOT EXISTS (SELECT * FROM SC Y WHERE Y.Sno=200215122 AND NOT EXISTS (SELECT * FROM SC Z WHERE Z.Sno=X.Sno AND Y.Cno=Z.Cno ))

学了except想到另一种做法

SELECT * FROM SC EXCEPT SELECT * FROM SC Y WHERE Sno=200215122 AND NOT EXISTS (SELECT * FROM SC Z WHERE Z.Cno=Y.Cno);

SELECT * FROM Student WHERE Sdept='CS' UNION SELECT * FROM Student WHERE Sage<=19;
SELECT * FROM Student WHERE Sdept='CS' OR Sage<=19;