题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select id,job,score from grade as a
where score > (select avg(score) from grade as b where
a.job = b.job group by job )
order by id asc;
