题解 | #考试分数(二)#--相关子查询
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
# 使用相关子查询
select *
from grade g
where score > (
select avg(score) from grade
where grade.job = g.job
)
order by id;
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
# 使用相关子查询
select *
from grade g
where score > (
select avg(score) from grade
where grade.job = g.job
)
order by id;
相关推荐