In one query, count the orders per shipping_city and, separately, per status.
Don't include rows for a city and status together. Show:
dimension: city or statusvalue: the city, or the status as textorders: the number of ordersEnd your query with ORDER BY dimension, orders DESC, value.
| orders |
|---|
| order_id (PK) |
| status |
| shipping_city |
In one query, count the orders per shipping_city and, separately, per status.
Don't include rows for a city and status together. Show:
dimension: city or statusvalue: the city, or the status as textorders: the number of ordersEnd your query with ORDER BY dimension, orders DESC, value.
| orders |
|---|
| order_id (PK) |
| status |
| shipping_city |
| dimension | value | orders |
|---|---|---|
| city | Mumbai | 41 |
| city | Lucknow | 35 |
| city | Delhi | 34 |
| city | Pune | 31 |
| city | Bengaluru | 30 |
| city | Hyderabad | 30 |
| city | Chennai | 29 |
| city | Kochi | 29 |
| city | Kolkata | 28 |
| city | Jaipur | 25 |
| city | Ahmedabad | 1 |
| city | Goa | 1 |
| city | Patna | 1 |
| status | delivered | 114 |
| status | returned | 45 |
| status | cancelled | 44 |
| status | pending | 43 |
| status | shipped | 39 |
| status | confirmed | 30 |
Run query to see output