建立一个表得出每个科目的平均分，再进行连表比较

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