根据job分组汇总,并算出每组score的平均值,取三位小数。最后按平均值逆排序。
select job, round(avg(score),3) as avg from grade group by job order by avg desc