Show shipping_city and revenue (the total total_amount of its orders with the status
delivered) for the five cities with the most delivered revenue.
End your query with ORDER BY revenue DESC, shipping_city LIMIT 5.
| orders |
|---|
| order_id (PK) |
| status |
| total_amount |
| shipping_city |
Show shipping_city and revenue (the total total_amount of its orders with the status
delivered) for the five cities with the most delivered revenue.
End your query with ORDER BY revenue DESC, shipping_city LIMIT 5.
| orders |
|---|
| order_id (PK) |
| status |
| total_amount |
| shipping_city |
| shipping_city | revenue |
|---|---|
| Delhi | 155309.50 |
| Mumbai | 153323.55 |
| Lucknow | 148101.60 |
| Chennai | 144578.45 |
| Kochi | 140327.45 |
Run query to see output