题解 | #考试分数(二)#
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select
t.id,
t.job,
t.score
from
(
select
*,
avg(score) over (
partition by
job
) avgscore
from
grade
) t
where t.score>t.avgscore