题解 | #考试分数(二)#
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
- 复习相关子查询correlated subqueries的用法
SELECT * from grade g
WHERE score >
(SELECT avg(score) from grade where job=g.job)
order by id
考试分数(二)
http://www.nowcoder.com/practice/f456dedf88a64f169aadd648491a27c1
SELECT * from grade g
WHERE score >
(SELECT avg(score) from grade where job=g.job)
order by id
相关推荐