# Not Boring Movies LeetCode Solution

This Leetcode problem Not Boring Movies LeetCode Solution is done in SQL.

# List of all LeetCode Solution

## Problem Statement

id is the primary key (column with unique values) 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 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.

The result format is in the following example.

Example 1:
Input:

Output:

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

## Not Boring Movies LeetCode Solution MySQL

``````select
id,
movie,
description,
rating
from
cinema
where
id % 2 = 1
and description <> 'boring'
order by
rating desc;
```Code language: SQL (Structured Query Language) (sql)```
Scroll to Top