题解 | 考试分数(二)
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select
id,
job,
score
from grade g1
where score > (
select
avg(score)
from grade g2
where g2.job = g1.job
)
order by id asc;
查看25道真题和解析