针对表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
发布时间:2024-05-07 19:17:09