Highest-revenue city
Finance wants the flagship city. Find the city with the highest total fare from completed trips; on a tie, take the alphabetically earlier city. Return city and revenue, a single row.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| city | revenue |
|---|---|
| Moscow | 1200 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in