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