SQL Quest › SQL Interview Questions › Querying Basics

Recent Hit Movies (2010s)

EasyFreeQuerying Basics

The streaming editor is building a 'Critically Acclaimed 2010s' collection. Find movies released between 2010 and 2019 with a rating of 8.0 or higher. Show title, year, genre, rating. Sort by rating descending, then year ascending (so older classics break ties first).

Solve it in the browser editor →

Runs on SQLite in your browser, graded against the expected result, no signup. A wrong answer gets a diagnosis, not just "incorrect". Free accounts get 10 free challenge solves, and this can be one of them.

Schema

movies

id	title	year	genre	rating	votes	revenue_millions	runtime	director
1	Guardians of the Galaxy	2014	Action	8.1	757074	333.13	121	James Gunn
2	Prometheus	2012	Adventure	7	485820	126.46	124	Ridley Scott
3	Split	2016	Horror	7.3	157606	138.12	117	M. Night Shyamalan

Expected output: Rows from 2010-2019 with rating >= 8.0

Hint

BETWEEN 2010 AND 2019 is inclusive on both ends. Combine with AND rating >= 8.0. For the tie-breaker, use two keys in ORDER BY: rating DESC, year ASC.

Concepts

SELECT WHERE BETWEEN ORDER BY Filter & Sort

Practise the topic: SQL practice questions

Read the concept: Learn SQL for beginners

In these company practice sets

Netflix · Snowflake · Spotify

A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.

Recent Hit Movies (2010s)

Schema

Hint

Concepts

In these company practice sets

Related questions