Content Catalog
Return title and genre for all movies, ordered alphabetically by title.
- Sorting
Challenge brief
Understand the request
Content Strategy The content team wants a quick catalog snapshot before a genre-diversity review meeting.
List every title in the catalog with its genre.
Return
- title
- genre
Constraints
- Return every catalog title
- Order alphabetically by title
Data you will use
Review the relevant tables before deciding how to join, filter, or aggregate them.
movies
movie_idINTEGERtitleVARCHAR(100)genreVARCHAR(50)release_yearINTEGER
Hints, when you need them
Open one clue at a time so you still do the reasoning.
Hint 1
Title and genre are catalog attributes.
Hint 2
No activity table is needed for the complete catalog.
Hint 3
Project both fields and sort by title.
Verified SQL answer
Attempt the problem first, then compare structure and reasoning—not just syntax.
Reveal solution and explanation
SELECT title, genre FROM movies ORDER BY titleWhy this works
A single-table SELECT from movies. ORDER BY title gives the alphabetical listing the content team expects.
Success check
Returns the complete deterministic result for content catalog
Expected result
Use this output to verify values, aliases, ordering, and row count.
| title | genre |
|---|---|
| Dark | Sci-Fi |
| Extraction | Action |
| Money Heist | Crime |
| Narcos | Crime |
| Quiet Planet | Documentary |
| Stranger Things | Sci-Fi |
| The Crown | Drama |
Learn the concepts behind this answer
Strengthen your understanding with these targeted learning topics:
Continue practicing
Explore related company challenges
Google
Independent Google-style search, advertising, user-engagement, and video-product SQL practice.
Meta
Independent Meta-style social-product, engagement, content, community, messaging, and advertising SQL practice.
Airbnb
Independent Airbnb-style marketplace, booking, listing, payment, review, and guest analytics SQL practice.
Return to the complete interview preparation experience.