Netflix-style Company ChallengeEasyVerified answerSQLite live

Recent Content Releases

Return title and release_year for movies released after 2016, ordered by release_year then title.

  • Filtering
  • Sorting

Challenge brief

Understand the request

Content Acquisition The acquisition team wants to see which titles were added to the catalog after 2016 to benchmark against competitor release timelines.

List titles released after 2016 with their release year.

Return

  • title
  • release_year

Constraints

  • Return movies released after 2016
  • Order by release year, then title

Data you will use

Review the relevant tables before deciding how to join, filter, or aggregate them.

movies

  • movie_idINTEGER
  • titleVARCHAR(100)
  • release_yearINTEGER

Hints, when you need them

Open one clue at a time so you still do the reasoning.

Hint 1

Release year is a catalog attribute.

Hint 2

Apply the strict year boundary before projection.

Hint 3

Order first by year and then by title.

Verified SQL answer

Attempt the problem first, then compare structure and reasoning—not just syntax.

Reveal solution and explanation
SELECT title, release_year FROM movies WHERE release_year > 2016 ORDER BY release_year, title

Why this works

WHERE release_year > 2016 removes 2016-and-earlier titles. Ordering by release_year then title gives a chronological list that's also stable within the same year.

Success check

Returns the complete deterministic result for recent content releases

Expected result

Use this output to verify values, aliases, ordering, and row count.

titlerelease_year
Dark2017
Money Heist2017
Extraction2020
Quiet Planet2021

Learn the concepts behind this answer

Strengthen your understanding with these targeted learning topics:

Continue practicing

Explore related company challenges

SQL Interview Practice →

Return to the complete interview preparation experience.