# 先找到每一个工作的平均分
with t1 as (
    select job, AVG(score) as avg_score
    from grade
    group by job
)
select id, job, score
from (
    select a.*, t1.avg_score
    from grade as a
    left join t1
    on a.job = t1.job
) as c
where score > avg_score
order by id;