select id,a.job,score from grade as a
join
(select job, avg(score) as avgs
          from grade
          group by job
         )as b
on a.job=b.job
where score>avgs
order by id asc

自连接