596. 超过5名学生的课

596. 超过5名学生的课

---

题目链接：596. 超过5名学生的课

代码如下：

# Write your MySQL query statement below
select
    class
from 
    (select 
        class,count(student) as num 
    from 
        Courses 
    group by class) as t
where 
    num >= 5