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