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