Not Boring Movies
Classic
Problem Statement
A local cinema wants to promote specific movies from its database to improve viewer engagement. They are looking for movies that have an interesting description and follow a specific ID pattern.
Write an SQL query to report the movies with an odd-numbered ID and a description that is not "boring".
Rules:
- A movie ID is odd if it is not divisible by 2.
- The description check is case-sensitive (it must not be exactly "boring").
- Return all columns from the cinema table.
- Results must be sorted by rating in descending order.
Tests your understanding of
Basic SQL, Filtering, Modulo and String Matching
Input Tables
cinema
| id(INTEGER) | movie(VARCHAR) | description(VARCHAR) | rating(FLOAT) |
|---|---|---|---|
| 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 |
Expected Output
| id(INTEGER) | movie(VARCHAR) | description(VARCHAR) | rating(FLOAT) |
|---|---|---|---|
| 5 | House card | Interesting | 9.1 |
| 1 | War | great 3D | 8.9 |
Tags
EasyBasic SQLFilteringModuloString Matching
5-10 min
70%