单项选择题

在如下所示的“学生”数据表中,查询男生和女生的语文、数学、专业三门课程的平均分,正确的SQL语句是()。

A.SELECT 性别,AVG(语文) AS 语文平均分,AVG(数学) AS 数学平均分,AVG(专业) AS 专业平均分 FROM 学生
B.SELECT 性别,AVG(语文) AS 语文平均分,AVG(数学) AS 数学平均分,AVG(专业) AS 专业平均分 FROM 学生 ORDER BY 性别
C.SELECT 性别,AVG(语文) AS 语文平均分,AVG(数学) AS 数学平均分,AVG(专业) AS 专业平均分 FROM 学生 GROUP BY 性别
D.SELECT 性别,AVG(语文) AS 语文平均分,AVG(数学) AS 数学平均分,AVG(专业) AS 专业平均分 FROM 学生 ORDER BY 性别 ASC