109_not_boring_movies.md

SQL Everyday #109

Not Boring Movies

Site: LeetCode
Difficulty per Site: Easy

Problem

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. [Full Description]

Submitted Solution

-- Submitted Solution
SELECT
    *
FROM Cinema
WHERE id % 2 <> 0
AND description != 'boring'
ORDER BY rating DESC
;

Site Solution

-- LeetCode Solution 
-- TODO

Notes

TODO

NB

TBD

Go to Index
Go to Overview