FROM grade g,(SELECT job,avg(score) as score from grade group by job)a
where g.score > a.score and g.job=a.job
order by g.id;
FROM grade g,(SELECT job,avg(score) as score from grade group by job)a
where g.score > a.score and g.job=a.job
order by g.id;