题解 | #考试分数(二)#
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
with temp_table as (
SELECT *,
AVG(score) OVER(PARTITION BY job) AS 平均成绩
FROM grade
)
select g.id, g.job, g.score
from temp_table t
join grade g on t.id = g.id
where g.score > t.平均成绩
