题解 | 查询成绩
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
with avg as (
select sId , avg(score) as avg_score
from SC
group by sId
)
select count(*)
from avg
where avg.avg_score > 60
#简单到不敢相信,我都做了join,结果没用上
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
with avg as (
select sId , avg(score) as avg_score
from SC
group by sId
)
select count(*)
from avg
where avg.avg_score > 60
#简单到不敢相信,我都做了join,结果没用上
相关推荐
查看12道真题和解析