# 使用相关子查询
select *
from grade g
where score > (
    select avg(score) from grade 
    where grade.job = g.job
)
order by id;