问题详情

能正确查询出“没有选修课程编号为"C02"和"C04"这两门课的学生的学号和姓名“的选项有（）。

A.SELECT SNO,SN FROM S WHERE SNO NOT IN (SELECT SNO FROM SC WHERE CNO="C02" OR CNO="C04");

B.SELECT SNO,SN FROM S WHERE NOT EXISTS (SELECT * FROM SC WHERE (CNO="C02" OR CNO="C04") AND SC.SNO=S.SNO);

C.SELECT SNO,SN FROM S WHERE NOT EXISTS(SELECT * FROM SC WHERE CNO="C02" AND SC.SNO=S.SNO) AND NOT EXISTS (SELECT * FROM SC WHERE CNO="C04" AND SC.SNO=S.SNO);

D.SELECT DISTINCT S.SNO,SN FROM S,SC WHERE SC.SNO=S.SNO AND CNO<&