题解 | 查询成绩
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*) from (select b.sId from Student a join SC b on a.sId=b.sId join Course c on b.cId=c.cId group by b.sId having avg(b.score)>60 ) t1
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*) from (select b.sId from Student a join SC b on a.sId=b.sId join Course c on b.cId=c.cId group by b.sId having avg(b.score)>60 ) t1
相关推荐