• 2022-06-07
    针对表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
  • 举一反三