not boring movie

Not Boring Movies - LeetCode

Can you solve this real interview question? Not Boring Movies - Table: Cinema +----------------+----------+ | Column Name | Type | +----------------+----------+ | id | int | | movie | varchar | | description | varchar | | rating | float | +----------------+----------+ id is the primary key for this table.

https://leetcode.com/problems/not-boring-movies/submissions/896527623/

SELECT id, movie, description, rating
FROM Cinema
WHERE description != 'boring' and MOD(id, 2) = 1
ORDER BY rating DESC
;
SQL
복사