with avg_score_job as (
    select
        job,
        round(avg(score),2) as avg_score
    from 
        grade
    group by 
        job
)

select
    g.id,
    g.job,
    g.score
from 
    grade as g
left join 
    avg_score_job as a_s_j
on 
    g.job = a_s_j.job
where 
    g.score > a_s_j.avg_score
order by 
    g.id