Back to Playground Home

Find the boroughs that had the most rides in 2022

select lookup('taxiZones', 'borough', 'locationID', DOLocationID) AS borough, 
       count(*)
from nyctaxis 
WHERE tpep_dropoff_datetime > 1640995200000000
group by borough
order by count(*) DESC
limit 10