在学生表STUD中,查询既不是信息系“IS”、数学系“MA”,也不是计算机系"CS”的学生的姓名(XM)和性别(XB) 。实现该功能的正确SQL语句是______。
A.SELECT XM,XB FROM STUD WHERE SD IN("IS","MA","CS")
B.SELECT XM,XB FROM STUD WHERE SD NOT IN("IS","MA","CS")
C.SELECT XM,XB FROM STUD WHERE SD NOT("IS","MA","CS")
D.SELECT XM,XB FROM STUD WHERE SD NOT IN(IS,MA,C