实现“查询IS系或CS系的学生姓名和性别”的SELECT语句为()
A.
SELECT Sname, Ssex FROM Student WHERE Sdept='IS' AND Sdept='CS')
B.
SELECT Sname, Ssex FROM Student WHERE Sdept IN ['IS', 'CS']
C.
SELECT Sname, Ssex FROM Student WHERE Sdept IN {'IS', 'CS'}
D.
SELECT Sname, Ssex FROM Student WHERE Sdept IN ('IS', 'CS')