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