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.
Uzorak očekivanog izlaza
Ovako izgleda ispravan odgovor — broj redaka je njegov vlastiti, ne mora se podudarati s tablicama sheme.
| city | revenue |
|---|---|
| Moscow | 1200 |
Prijavi se da vidiš povijest predaja
PrijavaPrijavi se da koristiš AI mentora
Prijava