select id
, job
,score 
from grade g
where score >
(
select round(avg(score),3)
from grade sub 
where g.job = sub.job 
) 
order by id