30 Days Of LeetCode Database Day 26 - 620. Not Boring Movies

1Table: Cinema
2 
3+----------------+----------+
4| Column Name    | Type     |
5+----------------+----------+
6| id             | int      |
7| movie          | varchar  |
8| description    | varchar  |
9| rating         | float    |
10+----------------+----------+
11id is the primary key (column with unique values) for this table.
12Each row contains information about the name of a movie, its genre, and its rating.
13rating is a 2 decimal places float in the range [0, 10]

1Example 1:
2 
3Input: 
4Cinema table:
5+----+------------+-------------+--------+
6| id | movie      | description | rating |
7+----+------------+-------------+--------+
8| 1  | War        | great 3D    | 8.9    |
9| 2  | Science    | fiction     | 8.5    |
10| 3  | irish      | boring      | 6.2    |
11| 4  | Ice song   | Fantacy     | 8.6    |
12| 5  | House card | Interesting | 9.1    |
13+----+------------+-------------+--------+
14Output: 
15+----+------------+-------------+--------+
16| id | movie      | description | rating |
17+----+------------+-------------+--------+
18| 5  | House card | Interesting | 9.1    |
19| 1  | War        | great 3D    | 8.9    |
20+----+------------+-------------+--------+
21Explanation: 
22We have three movies with odd-numbered IDs: 1, 3, and 5. The movie with ID = 3 is boring so we do not include it in the answer.
23 

1**SQL**
2 
3SELECT * FROM Cinema WHERE 
4MOD(id, 2) != 0 AND description != 'boring' ORDER BY rating DESC;