Crime Genre Titles
Return the title of every movie in the Crime genre, ordered alphabetically.
- Filtering
- Sorting
Challenge brief
Understand the request
Content Licensing The licensing team is reviewing Crime content contracts and needs a current list of titles in that genre.
List all titles in the Crime genre.
Return
- title
Constraints
- Return only movies whose genre is 'Crime'
- 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)
Hints, when you need them
Open one clue at a time so you still do the reasoning.
Hint 1
Genre is stored with each catalog title.
Hint 2
Filter the catalog to the requested genre.
Hint 3
Return titles alphabetically.
Verified SQL answer
Attempt the problem first, then compare structure and reasoning—not just syntax.
Reveal solution and explanation
SELECT title FROM movies WHERE genre = 'Crime' ORDER BY titleWhy this works
WHERE genre = 'Crime' isolates Crime titles. ORDER BY title gives the alphabetical list the licensing team needs.
Success check
Returns the complete deterministic result for crime genre titles
Expected result
Use this output to verify values, aliases, ordering, and row count.
| title |
|---|
| Money Heist |
| Narcos |
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.