题解 | 查询成绩
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*)
from (
select sid, avg(score) as avgs
from SC
group by sid
having avg(score) > 60
) t;
#sql刷题#查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*)
from (
select sid, avg(score) as avgs
from SC
group by sid
having avg(score) > 60
) t;
#sql刷题#相关推荐
招聘动态