题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
内连接
select id,t1.job,score from grade t1
join (select job,avg(score) avg_score from grade t2 group by job ) t2 on t1.job=t2.job
where t1.score>t2.avg_score
order by id;