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