SQL Quest › SQL Interview Questions › Conditional Logic
Rounded Revenue: Top 10 from 2015+
A box-office summary report wants integer-rounded revenue for the 10 highest-grossing films released in 2015 or later — no decimals cluttering the row.
Show title, year, and ROUND(revenue_millions, 0) AS revenue_rounded. Filter to year >= 2015. Order by revenue_rounded descending. Limit 10.
ROUND(value, decimals) rounds to N decimal places. ROUND(x, 0) rounds to the nearest integer. ROUND(x, -2) rounds to the nearest hundred. SQLite, Postgres, and MySQL all support this signature.
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: Toy Story 4 | 2019 | 1073
Hint
SELECT, ROUND, WHERE, and open the hint there if you stall.Concepts
SELECT ROUND WHERE ORDER BY LIMIT Expressions
Practise the topic: SQL practice questions · CASE WHEN practice
Related questions
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