题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
#方法一:
select t1.id,t1.job,t1.score
from grade t1,
(select job,avg(score) avgs
from grade
group by job)t3
where t1.job=t3.job
and t1.score>t3.avgs
order by id ASC
#方法二:子查询
select id,job,score
from grade g1
where score >(
select avg(score)
from grade g2
where g1.job=g2.job
)
order by id asc