7-Day Inactive Users

We have two tables: users and rides. users Column Type user_id int city varchar(255) user_id is the primary key. rides Column Type ride_id int ride_date varchar(255) ride_rating float user_id int ride_id is the primary key. user_id references users. Write a query that counts how many users took no rides at all during the inclusive 7‑day window from 2024-07-01 through 2024-07-07. The count must include every user who has never taken a ride, regardless of when they signed up —…