“查询计算机科学系年龄大于19岁的学生”的SQL语句为（）。

A.SELECT * FROM S WHERE SDEP = ‘CS’ EXCEPT SELECT * FROM S WHERE SAGE<=19;

B.SELECT * FROM S WHERE SDEP = 'CS' AND SAGE > 19;

C.SELECT * FROM S WHERE SDEP = 'CS' AND SAGE <= 19;

D.SELECT * FROM S WHERE SDEP != 'CS' AND SAGE <= 19;

正确答案：SELECT * FROM S WHERE SDEP = ‘CS’ EXCEPT SELECT * FROM S WHERE SAGE<=19;；SELECT * FROM S WHERE SDEP = 'CS' AND SAGE > 19;