题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select g.*
from grade g
join (select job,avg(score) avgs
from grade
group by job) t
on g.job = t.job
where g.score > t.avgs
order by g.id
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select g.*
from grade g
join (select job,avg(score) avgs
from grade
group by job) t
on g.job = t.job
where g.score > t.avgs
order by g.id
相关推荐