select id, job, score
from (
    select id, job, score,
    avg(score) over (partition by job) as avg_score
    from grade
) temp
where score>avg_score
order by id