SELECT *
FROM grade AS g
WHERE g.score>(
SELECT AVG(a.score)
FROM grade AS a
WHERE g.job=a.job
)
ORDER BY id