select id,job,score 
from(
select  id ,job,score,avg(score)over(partition by job) as avg_score   from grade
)t 
where t.score > t.avg_score 
order by id