题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select a.id, a.job, a.score
from grade a
left join
(
select b.job,avg(b.score) as job_avg
from grade b
group by b.job
) as c
on a.job = c.job
where a.score>c.job_avg
order by id asc;
投递松下电子等公司6个岗位
这样才显得专业