题解 | 查询成绩
WITH
t AS (
SELECT
sId
FROM
SC
where
cId in (
select
cId
from
Course
where
cname in ('语文', '数学', '英语')
)
group by
sId
having
sum(score) > 180
)
select
count(*)
from
t
查看29道真题和解析