NYC Taxi — Borough Summary
NYC Taxi benchmark · all NYC Taxi queries
Trip statistics by borough
Representative SQL
Rendered for DataFusion with default parameters.
SELECT z.borough, COUNT(*) AS trip_count, SUM(t.total_amount) AS total_revenue, AVG(t.trip_distance) AS avg_distance, AVG(t.tip_amount) AS avg_tipFROM trips AS tLEFT JOIN taxi_zones AS z ON t.pickup_location_id = z.location_idWHERE t.pickup_datetime >= '2019-07-05' AND t.pickup_datetime < '2019-10-03' AND NOT z.borough IS NULLGROUP BY z.boroughORDER BY trip_count DESC NULLS LASTRepresentative DataFrame
No DataFrame implementation is registered for this query.
Get the exact query for your run
The blocks above are representative. To get the precise statement a specific platform runs at a specific scale, substitute your own values:
from benchbox import NYCTaxi
bench = NYCTaxi(scale_factor=1.0) # your scale factorqueries = bench.get_queries(dialect="datafusion") # your platform's dialect; drop dialect= for native SQLprint(queries['borough-summary'])Source
Query text: benchbox/core/nyctaxi/queries.py