题解 | 考试分数(二)
select g.id, g.job, g.score from grade g join (select job, sum(score)/count(job) avg from grade group by job) a on g.job=a.job where g.score>a.avg
select g.id, g.job, g.score from grade g join (select job, sum(score)/count(job) avg from grade group by job) a on g.job=a.job where g.score>a.avg
相关推荐