solve problem Classes More Than 5 Students

P-ppc · P-ppc · commit f8d79961cabf · 2018-11-15T20:09:38.000+08:00
diff --git a/README.md b/README.md
@@ -322,4 +322,5 @@ All solutions will be accepted!
 |#|Title|Solution|Difficulty|
 |:-|:-|:-|:-|
 |596|[Big Countries](https://leetcode-cn.com/problems/big-countries/description/)|[mysql](./database/BigCountries)|Easy|
-|182|[Duplicate Emails](https://leetcode-cn.com/problems/duplicate-emails/description/)|[mysql](./database/DuplicateEmails)|Easy|
+|182|[Duplicate Emails](https://leetcode-cn.com/problems/duplicate-emails/description/)|[mysql](./database/DuplicateEmails)|Easy|
+|596|[Classes More Than 5 Students](https://leetcode-cn.com/problems/classes-more-than-5-students/description/)|[mysql](./ClassesMoreThan5Students)|Easy|
diff --git a/database/ClassesMoreThan5Students/README.md b/database/ClassesMoreThan5Students/README.md
@@ -0,0 +1,2 @@
+# Classes More Than 5 Students
+This problem is easy to solve
diff --git a/database/ClassesMoreThan5Students/solution.sql b/database/ClassesMoreThan5Students/solution.sql
@@ -0,0 +1,2 @@
+# Write your MySQL query statement below
+select class from courses group by class having count(distinct student) >= 5

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+# Write your MySQL query statement below`
	`2`	`+select class from courses group by class having count(distinct student) >= 5`