SQLab — learn SQL in your browser

Average fare by tariff

MediumTaxi serviceJOIN + AVG40 XP

Show the average fare of completed trips on each tariff: the tariff name and the average fare rounded to a whole number.

Tables · Taxi service

driversDrivers64 rows

carsCars69 rows

tariffsTariffs4 rows

ridersRiders230 rows

tripsTrips1,600 rows

paymentsPayments1,446 rows

Sign in to open this section

Sign in to solve problems and play the arena. It takes less than a minute.

Tables · Taxi service

driversDrivers64 rows

carsCars69 rows

tariffsTariffs4 rows

ridersRiders230 rows

tripsTrips1,600 rows

paymentsPayments1,446 rows