题解 | #考试分数(二)#
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select
id,job,score
from
(
select
id
,job
,score
,avg(score) over (partition by job) as avg_score
from
grade
) as a
where score > avg_score
group by id
查看12道真题和解析