Table Name: Rides Columns: ride_id, start_time, end_time, passenger_id, driver_id, ride_region, ride_completed (Y/N), pick_up_location (lat/long), drop_off_location (lat/long), distance_between_pickup_and_dropoff
Query: Need to write a query that returns, for each of the last 90 days, a count of the rides taken in the 7 day window preceding that day.
Im trying to solve this is preferably in Postgres or snowflake. Can someone provide ideas/help?