select a.id,a.job,a.score
from grade a join
(select job,round(avg(score),3) avg
from grade
group by job) t
on a.job=t.job and a.score>t.avg
order by a.id;