码码猫

题解

/ 注册

全部文章 / 题解（共1篇）

题解 | #考试分数(二)#

select t1.id,t1.job,t1.score from grade t1 left join (select job,avg(score) avg from grade group by job) t2 on t1.job=t2.job where t1.score>t2.avg ...

Mysql

2021-09-29

0 306