SELECT 
    DATE(pickup_datetime) as date, 
    passenger_count, 
    COUNT(1) as trip_count 
FROM `nyc-tlc.yellow.trips`
WHERE 
    pickup_datetime >= '{{start_date}}' AND 
    pickup_datetime < '{{end_date}}'
group by 1,2
