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