Rank products by revenue (highest first, ties by product_id) and return product_name, revenue and cum_pct — cumulative % of total revenue (2 decimals).
11 rows with columns product_name, revenue, cum_pct — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Smartwatch | 24795 | 26.76 |
| 2 | Running Shoes | 14595 | 42.51 |
| 3 | Coffee Maker | 10297 | 53.62 |
Run your code to see the output here.