refactor 596

fishercoder1534 · fishercoder1534 · commit b704d101f3e8 · 2019-07-24T06:59:14.000-07:00
diff --git a/database/_596.sql b/database/_596.sql
@@ -1,3 +1,36 @@
+--596. Classes More Than 5 Students
+--SQL Schema
+--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:
+--
+--+---------+------------+
+--| student | class      |
+--+---------+------------+
+--| A       | Math       |
+--| B       | English    |
+--| C       | Math       |
+--| D       | Biology    |
+--| E       | Math       |
+--| F       | Computer   |
+--| G       | Math       |
+--| H       | Math       |
+--| I       | Math       |
+--+---------+------------+
+--Should output:
+--
+--+---------+
+--| class   |
+--+---------+
+--| Math    |
+--+---------+
+--
+--
+--Note:
+--The students should not be counted duplicate in each course.
+
 select class from courses
 group by class
 having count(distinct student) >= 5;
