Pareto: Cumulative Revenue Share

hard
Unit 23 · Window Functions 110/0 to milestone

Is revenue concentrated in a few customers? Rank customers who have ordered by total spend (highest first, ties by name), and return name, spend and cumulative_pct: the running share of total revenue up to and including that customer, rounded to 1 decimal place.

Pro problem

Unlock this and every premium problem across all tracks — plus hidden-test grading, advanced AI engineering modules and new content every week.

Start 7-day free trial
query.sql · SQLite
Run your code to see results. ⌘↵ to run · ⌘⇧↵ to submit
Pareto: Cumulative Revenue Share · TechGradify