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