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.
Eksempel på forventet output
Sådan ser et korrekt svar ud — dets rækketal er dets eget og behøver ikke at matche skematabellerne.
| city | revenue |
|---|---|
| Moscow | 1200 |
Log ind for at se indsendelseshistorik
Log indLog ind for at bruge AI-mentor
Log ind