SQLab — learn SQL in your browser

Fleet by year

MediumTaxi serviceGROUP BY40 XP

Count the cars made in 2018 or later by year: year and the number of cars, by year ascending.

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