select g.id,g.job,g.score 
from grade g,
(
    select job ,round(sum(score)*1.0 / count(score),3) as s 
    from grade 
    group by job
)as avg_s
where g.job=avg_s.job
and g.score>avg_s.s