题解 | #内联平均分成绩表#
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select g.id, g.job, g.score
from grade g
inner join (
select job, avg(score) savg
from grade
group by job
) t
on t.job = g.job
where g.score > t.savg
order by g.id
