```# 运用窗口函数计算出不同岗位均分作为新的字段，筛选出各个岗位的高分即可
SELECT a.id,a.job,a.score
from (SELECT id,job, score,avg(score) over(partition by job ) as avg_s
from grade) a
where a.score > a.avg_s