620. Not Boring Movies.sql

/*
Question 620. Not Boring Movies
Link: https://leetcode.com/problems/not-boring-movies/description/

Table: Cinema

+----------------+----------+
| Column Name    | Type     |
+----------------+----------+
| id             | int      |
| movie          | varchar  |
| description    | varchar  |
| rating         | float    |
+----------------+----------+
id is the primary key (column with unique values) for this table.
Each row contains information about the name of a movie, its genre, and its rating.
rating is a 2 decimal places float in the range [0, 10]
 

Write a solution to report the movies with an odd-numbered ID and a description that is not "boring".

Return the result table ordered by rating in descending order.
*/

SELECT 
    id,
    movie,
    description,
    rating
FROM Cinema
WHERE id % 2 = 1 AND description != 'boring'
ORDER BY rating DESC;

-- OR with ANSI SQL standard

SELECT 
    id,
    movie,
    description,
    rating
FROM Cinema
WHERE id % 2 = 1 AND description <> 'boring' -- noqa: CV01
ORDER BY rating DESC