题解 | #考试分数(二)#
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select a.* from grade a, (select job,avg(score) av from grade group by job) b where a.job=b.job and a.score > b.av
考试分数(二)
https://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select a.* from grade a, (select job,avg(score) av from grade group by job) b where a.job=b.job and a.score > b.av
相关推荐