Inactive User Analysis

Problem: Inactive User Analysis Given: users(user_id, city) rides(ride_id, ride_date, ride_rating, user_id) Count users with zero rides in the 7-day window ending on 2024-07-07, inclusive: 2024-07-01 through 2024-07-07. Users who signed up but never took a ride must be included. Return one column: inactive_user_count.