算出平均工资表连接即可

select id,t.job,t.score from grade as t join (select job ,avg(score) as 平均工资 from grade group by job) as c on c.job=t.job where t.score>平均工资 ;