List every city that appears as a customer's city or as an order's shipping_city,
each city once, in one column named city.
End your query with ORDER BY city.
| customers |
|---|
| customer_id (PK) |
| city |
| orders |
|---|
| order_id (PK) |
| shipping_city |
List every city that appears as a customer's city or as an order's shipping_city,
each city once, in one column named city.
End your query with ORDER BY city.
| customers |
|---|
| customer_id (PK) |
| city |
| orders |
|---|
| order_id (PK) |
| shipping_city |
| city |
|---|
| Ahmedabad |
| Bengaluru |
| Bhopal |
| Chennai |
| Delhi |
| Goa |
| Hyderabad |
| Indore |
| Jaipur |
| Kochi |
| Kolkata |
| Lucknow |
| Mumbai |
| Patna |
| Pune |
| Surat |
| Varanasi |
Run query to see output