题解 | 查询成绩

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