Skip to main content
  1. Problem Solving Solutions/

Not Boring Movies LeetCode Solution

·1 min read
Leetcode SQL
Mayukh Datta
Author
Mayukh Datta
Table of Contents

X city opened a new cinema, many people would like to go to this cinema. The cinema also gives out a poster indicating the movies’ ratings and descriptions.

Please write a SQL query to output movies with an odd numbered ID and a description that is not ‘boring’. Order the result by rating.

For example, table cinema:

+———+———–+————–+———–+ | id | movie | description | rating | +———+———–+————–+———–+ | 1 | War | great 3D | 8.9 | | 2 | Science | fiction | 8.5 | | 3 | irish | boring | 6.2 | | 4 | Ice song | Fantacy | 8.6 | | 5 | House card| Interesting| 9.1 | +———+———–+————–+———–+

For the example above, the output should be:

+———+———–+————–+———–+ | id | movie | description | rating | +———+———–+————–+———–+ | 5 | House card| Interesting| 9.1 | | 1 | War | great 3D | 8.9 | +———+———–+————–+———–+

Link: https://leetcode.com/problems/not-boring-movies/

Solution
#

select * from cinema where mod(id, 2) <> 0 and description <> ‘boring’ order by rating desc;