题解 | SQLW16 查询出语文，数学，英语3科的平均成绩大于60分的学生人数
WITH t1 AS (
SELECT
SC.sId,
SC.cid,
score
FROM SC
LEFT JOIN Course c
ON SC.cid = c.cid
WHERE c.cname in ('语文','数学','英语')
),
t2 AS (
SELECT
sid,
AVG(score) AS avg_score
FROM t1
GROUP BY sid
HAVING avg_score > 60
)SELECT count(*) AS
`count(*)` FROM t2;
# 这道题关键在于表名要归一化！
阿里巴巴公司氛围 651人发布