姓名 分数 课程
name score course
1 math 80
1 english 90
2 math 81
2 english 91
3 math 85
3 english 95
1 chinese 92
SELECT
stuid,
sum(case when score>=90 then 1 else 0 end)
FROM
score
GROUP BY
stuid
姓名 分数 课程
name score course
1 math 80
1 english 90
2 math 81
2 english 91
3 math 85
3 english 95
1 chinese 92
SELECT
stuid,
sum(case when score>=90 then 1 else 0 end)
FROM
score
GROUP BY
stuid