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
题目链接: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