查询每门课程的最高分,要求得到的信息包括课程名称和分数,正确的命令是( )
A.
SELECT 课程名称,SUM(分数)AS分数 FROM curriculum, grade WHERE curriculum. 课程编号= grade.课程编号 GROUP BY课程名称
B.
SELECT 课程名称,MAX(分数)AS分数 FROM curriculum, grade WHERE curriculum. 课程编号= grade.课程编号 GROUP BY课程名称
C.
SELECT 课程名称,SUM(分数)AS分数 FROM curriculum, grade WHERE curriculum. 课程编号= grade.课程编号
D.
SELECT 课程名称,MAX(分数)AS分数 FROM curriculum, grade WHERE curriculum. 课程编号= grade.课程编号