1、求均值：avg函数
2、保留三位小数:round(XXX,3)
3、分组聚合 group by
4、降序 order,desc

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