题解 | #考试分数(一)#

   -- select job|avg(1.0*score) from grade  group by job  ;
      select   job ,  round((1.0*sum(score)/count(id) ),3) as a from grade  group by job  order by a desc ;