题解 | #内联平均分成绩表#

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