题解 | 查询成绩
查询成绩
https://www.nowcoder.com/practice/ef30689ae065434c89c129e9dfe1b4cd
select count(*)
from (
select sId
from SC
left join Course on SC.cId = Course.cId
where cname in ('语文','数学','英语')
group by sId
having count(distinct cname) = 3 and sum(score)/3 > 60
) as s1
投递阿里云等公司7个岗位