1.分析
round(avg(score),3) 用来取平均后保留3位小数,
还是别忘了先对job分组,再对平均数排序。

2.代码

SELECT job, ROUND(AVG(score), 3) AS a 
FROM grade
GROUP BY job
ORDER BY a DESC