题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
算出平均工资表连接即可
select id,t.job,t.score from grade as t join (select job ,avg(score) as 平均工资 from grade group by job) as c on c.job=t.job where t.score>平均工资 ;
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
算出平均工资表连接即可
select id,t.job,t.score from grade as t join (select job ,avg(score) as 平均工资 from grade group by job) as c on c.job=t.job where t.score>平均工资 ;
相关推荐