select g1.id, g1.job, g1.score
from grade g1 join (
select job,round(avg(score),3) avg
from grade
group by job) g2
on g1.job = g2.job
where g1.score > g2.avg
order by g1.id;