题解 | #考试分数(二)#
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
# 先找到每一个工作的平均分
with t1 as (
select job, AVG(score) as avg_score
from grade
group by job
)
select id, job, score
from (
select a.*, t1.avg_score
from grade as a
left join t1
on a.job = t1.job
) as c
where score > avg_score
order by id;
