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