DataTalksClub/data-engineering-zoomcamp

Question $-week_1_docker_sql_homework

ditirodt opened this issue · 0 comments

ditirodt commented

Does the question need a day with high frequency of pick-up time or a day with high total distance covered? When I use following SQL statement:

  • SELECT DATE(lpep_pickup_datetime) as pickup_date, SUM(trip_distance) as total_distance FROM green_taxi_data GROUP BY pickup_date ORDER BY total_distance DESC LIMIT 1;

I get, 2019-01-25 | 83745.79000000033 which not on date choices for the question.