查询每门课程的最高分,要求得到的信息包括课程名称和分数,正确的命令是()
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.课程编号