题解 | #创建一个actor_name表#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select a.id,a.job,a.score
from grade a join
(select job,round(avg(score),3) avg
from grade
group by job) t
on a.job=t.job and a.score>t.avg
order by a.id;
投递OPPO等公司10个岗位 >