SQL Quest › SQL Interview Questions › Window Functions
Cumulative Revenue Share (Pareto)
Build a Pareto analysis of movies by revenue. Using a CTE, rank movies by revenue_millions descending, then show title, revenue_millions, cumulative_revenue (running sum, rounded to 2 decimals), and cumulative_pct (running sum as % of total revenue, rounded to 1 decimal). Exclude movies with null revenue. Sort by revenue_millions descending, then title ascending as a tie-breaker. Pareto analysis is asked at Netflix and Spotify because it reveals the 80/20 rule in content performance.
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: A: 50.0%, B: 80.0%, C: 100.0%
Hint
Concepts
SELECT Window Functions SUM ROUND Window Functions + CTE
Practise the topic: SQL practice questions · Window function practice · GROUP BY exercises · CTE practice · Advanced SQL interview questions
In these company practice sets
Anthropic · Apple · Morgan Stanley · Netflix · OpenAI · Ramp · Shopify · Snowflake · Spotify · Stripe
A SQL Quest challenge matched to patterns reported for these companies — not a question any of them has published.
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