Operations wants to know which order statuses occur in which cities. List each
combination of shipping_city and status that appears in orders, once.
End your query with ORDER BY shipping_city, status.
status sorts in its defined order (pending, confirmed, shipped, delivered, cancelled, returned), not A–Z.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
Operations wants to know which order statuses occur in which cities. List each
combination of shipping_city and status that appears in orders, once.
End your query with ORDER BY shipping_city, status.
status sorts in its defined order (pending, confirmed, shipped, delivered, cancelled, returned), not A–Z.
| orders |
|---|
| order_id (PK) |
| customer_id (FK) |
| order_date |
| status |
| total_amount |
| shipping_city |
| shipping_city | status |
|---|---|
| Ahmedabad | cancelled |
| Bengaluru | pending |
| Bengaluru | confirmed |
| Bengaluru | shipped |
| Bengaluru | delivered |
| Bengaluru | cancelled |
| Bengaluru | returned |
| Chennai | pending |
| Chennai | confirmed |
| Chennai | shipped |
| Chennai | delivered |
| Chennai | cancelled |
| Chennai | returned |
| Delhi | pending |
| Delhi | confirmed |
| Delhi | shipped |
| Delhi | delivered |
| Delhi | cancelled |
| Delhi | returned |
| Goa | confirmed |
| Hyderabad | pending |
| Hyderabad | confirmed |
| Hyderabad | shipped |
| Hyderabad | delivered |
| Hyderabad | cancelled |
| Hyderabad | returned |
| Jaipur | pending |
| Jaipur | confirmed |
| Jaipur | shipped |
| Jaipur | delivered |
| Jaipur | cancelled |
| Jaipur | returned |
| Kochi | pending |
| Kochi | confirmed |
| Kochi | shipped |
| Kochi | delivered |
| Kochi | cancelled |
| Kochi | returned |
| Kolkata | pending |
| Kolkata | confirmed |
| Kolkata | shipped |
| Kolkata | delivered |
| Kolkata | cancelled |
| Kolkata | returned |
| Lucknow | pending |
| Lucknow | confirmed |
| Lucknow | shipped |
| Lucknow | delivered |
| Lucknow | cancelled |
| Lucknow | returned |
| Mumbai | pending |
| Mumbai | confirmed |
| Mumbai | shipped |
| Mumbai | delivered |
| Mumbai | cancelled |
| Mumbai | returned |
| Patna | pending |
| Pune | pending |
| Pune | confirmed |
| Pune | shipped |
| Pune | delivered |
| Pune | returned |
Run query to see output