Genre Filtering
ASKED IN INTERVIEWNetflix
Problem Statement
Netflix is preparing a retrospective for its 2025 content. The production team needs a list of all titles that were released in 2025 and fall strictly under the category of Documentary.
Write an SQL query to retrieve these specific titles.
Rules:
- The genre must be exactly Documentary.
- The release_year must be 2025.
- Output columns: title, release_year.
- Sort the results by title in ascending order.
Table Schema:
- Movies: movie_id, title, genre, release_year, rating.
Tests your understanding of
Basic SQL, Filtering and Logical Operators
Input Tables
Movies
| title(VARCHAR) | genre(VARCHAR) | release_year(INTEGER) |
|---|---|---|
| The Last Glacier | Documentary | 2025 |
| Ocean Life | Documentary | 2024 |
| Fast & Furious 15 | Action | 2025 |
| AI Revolution | Documentary | 2025 |
| The Chef | Comedy | 2025 |
| Space Journey | Documentary | 2025 |
Expected Output
| title(VARCHAR) | release_year(INTEGER) |
|---|---|
| AI Revolution | 2025 |
| Space Journey | 2025 |
| The Last Glacier | 2025 |
Tags
EasyASKED IN INTERVIEWBasic SQLFilteringLogical Operators
5-10 min
85%