统计出各门课程考试成绩的最高分、最低分,下面查询统计语句正确的是( )
A.
select 课程,max(score),min(score) from student_score
B.
select 课程,max(score),min(score) from student_score group by score
C.
select 课程,max(score),min(score) from student_score group by 课程
D.
select 课程,max(score),min(score) from student_score having 课程