sovle problem Not Boring Movies

P-ppc · P-ppc · commit 8b41587d96fd · 2018-11-21T22:46:15.000+08:00
diff --git a/README.md b/README.md
@@ -323,4 +323,5 @@ All solutions will be accepted!
 |:-|:-|:-|:-|
 |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|
-|596|[Classes More Than 5 Students](https://leetcode-cn.com/problems/classes-more-than-5-students/description/)|[mysql](./ClassesMoreThan5Students)|Easy|
+|596|[Classes More Than 5 Students](https://leetcode-cn.com/problems/classes-more-than-5-students/description/)|[mysql](./ClassesMoreThan5Students)|Easy|
+|620|[Not Boring Movies](https://leetcode-cn.com/problems/not-boring-movies/description/)|[mysql](./database/NotBoringMovies)|Easy|
diff --git a/database/NotBoringMovies/README.md b/database/NotBoringMovies/README.md
@@ -0,0 +1,2 @@
+# Not Boring Movies
+This problem is easy to solve
diff --git a/database/NotBoringMovies/solution.sql b/database/NotBoringMovies/solution.sql
@@ -0,0 +1,2 @@
+# Write your MySQL query statement below
+select * from cinema where description != 'boring' and id % 2 = 1 order by rating desc

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,2 @@`
	`1`	`+# Write your MySQL query statement below`
	`2`	`+select * from cinema where description != 'boring' and id % 2 = 1 order by rating desc`