596.Classes More Than 5 Students
596.Classed More Than 5 Students
难度:Easy
SQL架构 There is a table courses with columns: student and class
Please list out all classes which have more than or equal to 5 students.
For example, the table:
1
+---------+------------+
2
| student | class |
3
+---------+------------+
4
| A | Math |
5
| B | English |
6
| C | Math |
7
| D | Biology |
8
| E | Math |
9
| F | Computer |
10
| G | Math |
11
| H | Math |
12
| I | Math |
13
+---------+------------+
14
Should output:
15
16
+---------+
17
| class |
18
+---------+
19
| Math |
20
+---------+
21
Copied!
Note: The students should not be counted duplicate in each course.
1
# Write your MySQL query statement below
2
select class from courses group by class having count(distinct student)>=5 ;
Copied!
执行用时 :299 ms, 在所有 C++ 提交中击败了88.32%的用户 内存消耗 : N/A
Copy link