【简答题】With the difficulty of finding a perfect job, there is an increasing favor of getting a s degree nowadays. Someone said that s degree is essential with the development of the society and o...
SELECT DISTINCT Sno FROM SC S1 WHERE NOT EXISTS ( SELECT cno FROM SC S2 WHERE S2.Sno = '201215122 ' AND cno not in (SELECT cno FROM SC S3 WHERE S3.Sno=S1.Sno AND S3.Cno=S2.Cno) )
D.
SELECT DISTINCT Sno FROM SC S1 WHERE NOT EXISTS ( SELECT cno FROM SC S2 WHERE S2.Sno = ' 201215122 ' AND not EXISTS (SELECT * FROM SC S3 WHERE S3.Sno=S1.Sno AND S3.Cno=S2.Cno) );