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

select g1.id,g1.job,g1.score
from grade g1
where g1.score>(select round(avg(g2.score),3)from grade g2 where g1.job=g2.job group by g2.job) -- 岗位要一致，才能比较
-- group by g1.job --没有聚合函数不用分组
order by g1.id
;