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

  • 考察聚合函数的使用