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.
| city | revenue |
|---|---|
| Moscow | 1200 |
Logi sisse, et näha esituste ajalugu
Logi sisseLogi sisse, et kasutada AI mentorit
Logi sisse