题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select id,job,score
from(
select *,avg(score)over(partition by job) pj
from grade
) hh
where hh.score > hh.pj
order by id
from(
select *,avg(score)over(partition by job) pj
from grade
) hh
where hh.score > hh.pj
order by id
查看10道真题和解析