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

easy 水一天 哈哈