该篇文章展示了如何从score表中按平均成绩对课程进行排序，并提取出前三名课程，包括科目名称、系别和人数信息。SQL查询涉及了聚合函数avg()和子查询的使用。
select courseId,avg(result) from score group by courseId;
select courseId,avg(result) from score group by courseId
order by avg(result) desc limit 3;
select courseName '科目名称',department '系别',number '人数'
from course where id in(
select courseId from score group by courseId
order by avg(result) desc
)limit 3;
扫一扫
2810
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
