题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
```# 运用窗口函数计算出不同岗位均分作为新的字段，筛选出各个岗位的高分即可
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
