查询信息系(IS)、数学系(MA)和计算机科学系(CS)学生的姓名和性别,下列正确的有( ) (5.0分) A. SELECT Sname,Ssex FROM Student WHERE Sdept IN ( 'IS','MA','CS' ); B. SELECT Sname,Ssex FROM Student WHERE Sdept= 'IS' or Sdept='MA' or Sdept='CS' ; C. SELECT Sname,Ssex FROM Student WHERE Sdept= 'IS' and Sdept='MA' and Sdept='CS' ; D. SELECT Sname,Ssex FROM Student WHERE Sdept not IN ( 'IS','MA','CS' );