![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
查询每门课程的最高分,要求得到的信息包括课程名称和分数,正确的命令是——
A.
SELECT 课程名称,SUM(成绩)AS分数 FROM curriculum, grade WHERE curriculum. 课程编号= grade.课程编号 GROUP BY 课程名称
B.
SELECT 课程名称,MAX(成绩)分数 FROM curriculum, grade WHERE curriculum. 课程编号= grade.课程编号 GROUP BY 课程名称
C.
SELECT 课程名称,SUM(成绩)分数 FROM curriculum, grade WHERE curriculum. 课程编号= grade.课程编号 GROUP BY curriculum. 课程名称
D.
SELECT 课程名称,MAX(成绩)AS分数 FROM curriculum, grade WHERE curriculum. 课程编号= grade.课程编号 GROUP BY curriculum. 课程名称