查询每门课程的最高分,要求得到的信息包括课程名称和分数,正确的命令是()
A.
SELECT 课程名称,SUM (分数) as 分数 from curricum.课程编号 = 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 CUEEICULUM, grade WHERE curriculum.课程编号= grade.课程编号 GROUP BY curriculum. 课程编号