针对学生选课表sc(sno, cno, grade),其中sno为学号,cno为课程号,grade为成绩。以下哪个操作( )统计出每位学生所选课程的最高分和最低分。
A:select sno,avg(grade), sum(grade) from sc group by sno
B:select sno,max(grade), min(grade) from sc
C:select sno,max(grade), min(grade) from sc group by sno
D:select sno,max(grade), min(grade) from sc order by sno
发布时间:2024-05-07 19:17:09