单项选择题
针对表SC(sno, cno, grade),其中sno为学号,cno为课程号,grade为成绩。以下哪个操作( )统计出每位学生所选课程的最高分和最低分。
A、select sno,max(grade), min(grade) from sc
B、select sno,max(grade), min(grade) from sc order by sno
C、select sno,max(grade), min(grade) from sc group by sno
D、select sno,avg(grade), sum(grade) from sc group by sno