题解 | 查询成绩
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*)
from (select sId
from SC
where cId in (select cId from Course where cname in ('语文','数学','英语'))
group by sId
having avg(score)>=60 and count(*) =3)a
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*)
from (select sId
from SC
where cId in (select cId from Course where cname in ('语文','数学','英语'))
group by sId
having avg(score)>=60 and count(*) =3)a
相关推荐