根据job分组汇总,并算出每组score的平均值,取三位小数。最后按平均值逆排序。

select job, round(avg(score),3) as avg from grade
group by job
order by avg desc