Last Updated: 11 Aug, 2021

Not Boring Movies

Moderate

Problem statement

Table: Cinema

Column Name	Data Type
id	INT
movie	VARCHAR
description	VARCHAR
rating	FLOAT

id is the primary key for this table.

Each row contains information about the name of a movie, its genre, and its rating.

rating is a 2 decimal places float in the range [0, 10]

Write an SQL query to report the movies with an odd-numbered ID and a description that is not "boring".

Return the result table in descending order by rating.

The query result format is in the following example:

Cinema table:
+----+------------+-------------+--------+
| 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    |
+----+------------+-------------+--------+

Result table:

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

We have three movies with odd-numbered ID: 1, 3, and 5. The movie with ID = 3 is boring so we don't include it in the answer.

Similar problems

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find the Quiet Students in All Exams

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Find Cumulative Salary of an Employee

Posted: 26 Aug, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Marvel Cities

Posted: 2 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Director's Actor

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021

Spotify Sessions

Posted: 3 Sep, 2021