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

List of all LeetCode Solution

Not Boring Movies 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)