题解 | #考试分数(二)#
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select
g1.*
from
grade g1
where
g1.score > (
select
avg(score)
from
grade g2
where
g1.job = g2.job
group by
g2.job
)
order by
g1.id
投递华为技术有限公司等公司10个岗位