leetcode

commit 12fa59173082a6a9507e699ca4a9c16702fa1243
parent 1a09407d602268dc36ade1c7dbb4ec1a4c1345b5
Author: AndrewLockVI <andrewlaack1@gmail.com>
Date:   Wed,  5 Jul 2023 19:27:33 -0500

Completed not boring movies using mySQL

Diffstat:
A
not-boring-movies/not-boring-movies.sql
 | 
6
++++++

1 file changed, 6 insertions(+), 0 deletions(-)
diff --git a/not-boring-movies/not-boring-movies.sql b/not-boring-movies/not-boring-movies.sql
@@ -0,0 +1,6 @@
+--Return all movies that have an odd number as the id
+--and do not have a description of boring
+SELECT *
+FROM Cinema
+WHERE Cinema.id % 2 = 1 and Cinema.description != 'boring'
+ORDER BY Cinema.rating DESC