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) );