题解 | 查询成绩
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
with t as (
select stu.sId
from Student stu
join (
select sId, cId, score
from SC
group by sId, cId, score
) sc on stu.sId=sc.sId
join Course c on sc.cId=c.cId
group by stu.sId
having avg(sc.score)>60
)
select count(*)
from t
查看15道真题和解析

滴滴公司氛围 1801人发布