For each customer city with orders, return orders and cancel_pct (cancelled ÷ all, 2 decimals).
12 rows with columns city, orders, cancel_pct — first 3 shown:
| # | |||
|---|---|---|---|
| 1 | Ahmedabad | 4 | 0 |
| 2 | Surat | 2 | 0 |
| 3 | Delhi | 5 | 20 |
Run your code to see the output here.