SELECT passenger_count, year(pickup_datetime), count(*) FROM trips_parquet GROUP BY passenger_count, year(pickup_datetime); The following completed in 85.942 seconds..SELECT passenger_count, year(pickup_datetime) trip_year, round(trip_distance),…
Continue Reading