SQL Quest › SQL Interview Questions › Querying Basics
Pick Your Columns
You don't always need every column. Select just the title, year, and rating from the movies table. Order by year descending to see the newest movies first. Limit to 15 rows.
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".
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: 15 newest movies showing only title, year, rating
Hint
List the columns you want after SELECT, separated by commas. ORDER BY year DESC sorts newest first.
Concepts
SELECT
Practise the topic: SQL practice questions
Related questions
Your First QueryEasy · FreeFilter with WHEREEasy · FreeComparison OperatorsEasy · FreeMultiple Conditions (AND / OR)Easy · FreeThe IN OperatorEasy · FreeSorting and LimitingEasy · Free
Where would this cost you points in an interview?
Ten questions, no signup: a Skillmap across nine SQL skills and the one to fix first.
Take the readiness test