单选题设有学生表student，包含的属性有学号sno、学生姓名sname、性别sex、年龄age、所在专业smajor。下列语句正确的是______。

A、 SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B、 SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS"；
C、 SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno，sname FROM student WHERE Stupor="CS"；
D、 SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno，sname FROM student WHERE smajor="CS"；

【正确答案】 D

【答案解析】