Not Boring Movies
cinema has columns id, movie, description and rating (all ratings are different). Keep movies whose id is odd and whose description is not exactly "boring". Return their ids as a list, ordered by rating from highest to lowest.
Example 1
cinema {"id":[1,2,3,4],"movie":["a","b","c","d"],"description":["great","fun","boring","dull"],"rating":[8.5,9.0,9.5,6.0]}
returns [1]
Id 3 is boring, even ids are out, so only id 1 stays.
Constraints
- The result may be an empty list
Write it in your browser, against the clock. The model solution, stepped through line by line, comes after.