题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select a.* from grade a,
(select job,avg(score) as score from grade group by job) b
where a.job=b.job and a.score>b.score
order by a.id
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select a.* from grade a,
(select job,avg(score) as score from grade group by job) b
where a.job=b.job and a.score>b.score
order by a.id
相关推荐
找工作勤劳小蜜蜂:矛盾是没有实习,就是没实战经验,公司不想要,公司不要,你就没有实习,你就进入死循环,另外你的项目不是社会现在有大量岗位存在行业用的,云存储人员早就饱和。