#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.

Sampla aschuir a bhfuiltear ag súil leis

Seo é an chuma a bheadh ar fhreagra ceart — tá a líon rónna féin aige, ní gá dó na táblaí scéime a mheaitseáil.

cityrevenue
Moscow1200

Beidh toradh d'iarratais le feiceáil anseo