题解 | 查询成绩
with tmp as ( select sId,avg(score) as avgscore from SC group by sId having avg(score) > 60) select count(*) from tmp;
with tmp as ( select sId,avg(score) as avgscore from SC group by sId having avg(score) > 60) select count(*) from tmp;
相关推荐