题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select id ,job,score from grade
, (select avg(score) as avgs,job as jobs from grade group by job) as a
where score>a.avgs and job = a.jobs;
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
select id ,job,score from grade
, (select avg(score) as avgs,job as jobs from grade group by job) as a
where score>a.avgs and job = a.jobs;
相关推荐