考试分数(一)

简介

使用 round 与 avg

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