设有学生表 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" ；