按照学号进行分组，统计学生的平均成绩，且平均分按降序排列 A: select sid, avg(grade) from sc group by sid order by avg(grade) desc B: select sid, avg(grade) from sc group by cid order by avg(grade) desc C: select sid, avg(grade) from student group by sid order by avg(grade) desc D: select sid, avg(grade) from student group by cid order by avg(grade)

公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！
公告：维护QQ群：833371870，欢迎加入！

2022-06-09

按照学号进行分组，统计学生的平均成绩，且平均分按降序排列 A: select sid, avg(grade) from sc group by sid order by avg(grade) desc B: select sid, avg(grade) from sc group by cid order by avg(grade) desc C: select sid, avg(grade) from student group by sid order by avg(grade) desc D: select sid, avg(grade) from student group by cid order by avg(grade)

按照学号进行分组，统计学生的平均成绩，且平均分按降序排列
A: select sid, avg(grade) from sc group by sid order by avg(grade) desc
B: select sid, avg(grade) from sc group by cid order by avg(grade) desc
C: select sid, avg(grade) from student group by sid order by avg(grade) desc
D: select sid, avg(grade) from student group by cid order by avg(grade)

答案：

查看

举一反三