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

split好像没有用到呢