内连接
select id,t1.job,score from grade t1
join (select job,avg(score) avg_score from grade t2 group by job ) t2 on t1.job=t2.job
where t1.score>t2.avg_score
order by id;