1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12

-- @Title: 超过5名学生的课 (Classes More Than 5 Students)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 14:31:59
-- @Runtime: 223 ms
-- @Memory: 0 B
# Write your MySQL query statement below

select class
from courses
group by class 
having
count( distinct student) >= 5