LeetCode 620: Not Boring Movies
Solving LeetCode 620: Not Boring Movies Made Easy
I'm Varchasv, a Data Engineer working on enterprise data integration.
Currently on a 90-problem challenge to level up my technical skills and switch to a more development-focused role.
What I'm doing:
- Solving 2 Leetcode problems daily (SQL + DSA).
- Blogging about each problem.
- Building in public.
My Goal - Land a better data engineering role by mid-2026.
Follow my journey !!
Date: January 29, 2026
Category: SQL
Time Taken: 10 minute
Difficulty: Easy
Problem Statement
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.
Link: Not Boring Movies
My Approach
We will just put the conditions we need in the WHERE clause and at the end order them by rating.
Solution Code:
SELECT id, movie, description, rating
FROM Cinema
WHERE description != 'boring' AND id % 2 = 1
ORDER BY rating DESC
Pattern: Filter
Mistakes I Made: Very easy problem.
Series: 90 Days of Data Engineering Progress: 27/90 problems completed
Tags: #DEQuest #LeetCode #SQL #DataEngineering #BuildInPublic