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

取出高于平均分的人的信息，使用窗口函数