题解 | 考试分数(二)
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
with a as(
select job,avg(score) as avg
from grade
group by job)
select g.id,g.job,g.score
from a join grade g using(job)
where g.score>a.avg
order by g.id
首次错误：avg(score)进行了round取整，这样会丢掉哪些 真正大于avg(score)的情况
