题解 | 查询成绩
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*)
from (
select sid, sum(score)/COUNT(1) as s -- 不能聚合套聚合
from SC
where cid in (select cid from Course where cname in ('语文','数学','英语'))
group by sid
)a
where s > 60
从0开始的SQL之旅 文章被收录于专栏
从0开始的SQL之旅
