Genre Filtering

ASKED IN INTERVIEW
2pts
Netflix

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 GlacierDocumentary2025
Ocean LifeDocumentary2024
Fast & Furious 15Action2025
AI RevolutionDocumentary2025
The ChefComedy2025
Space JourneyDocumentary2025

Expected Output

title(VARCHAR)release_year(INTEGER)
AI Revolution2025
Space Journey2025
The Last Glacier2025

Tags

EasyASKED IN INTERVIEWBasic SQLFilteringLogical Operators
5-10 min
85%

Hints