select g.job, avg(g.score) as avg_score from grade as g group by g.job order by (avg_score) desc
分组后求平均值排序
暂无评论,快来抢首评~
相关推荐