1. 复习相关子查询correlated subqueries的用法
SELECT * from grade g
WHERE score >
(SELECT avg(score) from grade where job=g.job)
order by id