Revenue Contribution by Region With Rollup
Hard
group-by
Walmart
Amazon
Stripe
Calculate total revenue per region and channel, and include a grand total row. Use UNION ALL to simulate ROLLUP. Return region, channel, and total_revenue, with the grand total shown as region='ALL' and channel='ALL', ordered by region, channel.
Expected Output: Per-group totals plus a grand total row.
Tables
Hints (3 available)
SQL Editor
Output
Click "Run" to see results...