题目 : https://leetcode.cn/problems/classes-more-than-5-students/
数据
Create table If Not Exists Courses (
student varchar(255) comment '名字',
class varchar(255) comment '班级'
)
insert into Courses (student, class) values ('A', 'Math')
insert into Courses (student, class) values ('B', 'English')
insert into Courses (student, class) values ('C', 'Math')
insert into Courses (student, class) values ('D', 'Biology')
insert into Courses (student, class) values ('E', 'Math')
insert into Courses (student, class) values ('F', 'Computer')
insert into Courses (student, class) values ('G', 'Math')
insert into Courses (student, class) values ('H', 'Math')
insert into Courses (student, class) values ('I', 'Math')
需求
查询至少有5个学生 的所有班级
查询结果 :
| class |
| Math |
解决
select class
from Courses
group by class
having count(*) >= 5;