For each state, return customers (all customers in the state) and revenue (all their order items; 0 if none).
10 rows with columns state, customers, revenue — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Gujarat | 2 | 21234 |
| 2 | Delhi | 2 | 17688 |
| 3 | Uttar Pradesh | 1 | 6893 |
Run your code to see the output here.