#1120

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.

Oodatava väljundi näidis

Nii näeb õige vastus välja — selle ridade arv on omaette ega pea ühtima skeemi tabelitega.

cityrevenue
Moscow1200

Sinu päringu tulemus ilmub siia