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