题解 | 查询成绩
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*) from (select sid,avg(score) from SC group by 1 having avg(score) >60 and count(cid) = 3)a
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*) from (select sid,avg(score) from SC group by 1 having avg(score) >60 and count(cid) = 3)a
相关推荐