Ops wants a Pareto-style view of genre revenue: compute each genre's total revenue, then -- ordered from highest-revenue genre to lowest -- show a running cumulative total, so it's easy to see how many top genres account for most of the revenue.
Return GenreId, Name, Revenue, and RunningRevenueTotal, ordered by Revenue descending.
| Column | Type |
|---|---|
| GenreId | INTEGER (Primary Key) |
| Name | TEXT |
Ready to take your skills to the next level? Enroll in our comprehensive Data Analyst Career Track to master SQL, Python, Excel, and Power BI.
Run your code to see the result here.