题解 | #考试分数(一)#

select g.job, avg(g.score) as avg_score from grade as g group by g.job order by (avg_score) desc

分组后求平均值排序