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

思路：使用round函数针对求出的平均分保留3位小数点