# 596. 超过5名学生的课
# https://leetcode-cn.com/problems/classes-more-than-5-students/

# SQL架构
Create table If Not Exists Courses (student varchar(255), class varchar(255));
Truncate table Courses;
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');

# Write your MySQL query statement below
select
    class
from
    Courses
group by
    class
having
    count(distinct student) >= 5;

# clean-up
drop table Courses;