with
tb1 as(
    select id, job, score, avg(score) over(
        partition by job
    ) as avgscore
    from grade
),
tb2 as(
    select id, job, score, score - avgscore as diff from tb1
)
select id, job, score from tb2
where diff > 0
order by id