题解 | #考试分数(二)#

select
    t.id,
    t.job,
    t.score
from
    (
        select
            *,
            avg(score) over (
                partition by
                    job
            ) avgscore
        from
            grade
    ) t
where t.score>t.avgscore