#1122

Driver share of city revenue

Revenue-distribution analytics. For each driver, compute their share of their city's revenue from completed trips, as a percentage with two decimals. Ignore trips with no driver. Return driver_id and pct, ordered by driver.

Uzorak očekivanog izlaza

Ovako izgleda ispravan odgovor — broj redaka je njegov vlastiti, ne mora se podudarati s tablicama sheme.

pctdriver_id
66.671
33.332
1003

Ovdje će se pojaviti rezultat tvog upita