查询计算机系任意学生选修过的课程号，不正确的查询语句是： A: SELECT DISTINCT CnoFROM SCWHERE NOT EXISTS (SELECT SnoFROM StudentWHERE Sdept = 'CS'AND SSno = Student.Sno); B: SELECT DISTINCT CnoFROM SCWHERE EXISTS (SELECT SnoFROM StudentWHERE Sdept = 'CS'AND SSno = Student.Sno); C: SELECT DISTINCT CnoFROM SCWHERE Sno IN (SELECT SnoFROM StudentWHERE Sdept = 'CS'); D: SELECT DISTINCT CnoFROM SCLEFT JOIN StudentON SSno = Student.SnoWHERE Sdept = 'CS';

查询计算机系任意学生选修过的课程号，不正确的查询语句是： A: SELECT DISTINCT CnoFROM SCWHERE NOT EXISTS (SELECT SnoFROM StudentWHERE Sdept = 'CS'AND SC.Sno = Student.Sno); B: SELECT DISTINCT CnoFROM SCWHERE EXISTS (SELECT SnoFROM StudentWHERE Sdept = 'CS'AND SC.Sno = Student.Sno); C: SELECT DISTINCT CnoFROM SCWHERE Sno IN (SELECT SnoFROM StudentWHERE Sdept = 'CS'); D: SELECT DISTINCT CnoFROM SCLEFT JOIN StudentON SC.Sno = Student.SnoWHERE Sdept = 'CS';

查询每个学生及其选修课程的情况(不包括没有选修课程的学生),以下语句正确的为()(SQLSERVER平台中) A: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentrightjoinscon(student.sno=sc.sno) B: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentleftjoinscon(student.sno=sc.sno) C: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM Studentrightoutjoinscon(student.sno=sc.sno) D: SELECT Student.Sno,Sname,Ssex,Sage,Sdept,Cno,scoreFROM scleft outjoin Studenton(student.sno=sc.sno)