SQL for Rental Frequency | Dataford Interview Questions

Write a SQL query to find the monthly active users who rented a car more than twice in the last quarter.

For this exercise, treat the last quarter as January 1, 2025 through March 31, 2025. Include only completed rentals represented in the rentals table.

Output

One row per qualifying user and month.
Return rental_month, user_id, user_name, and rental_count.
Include only users with more than two rentals in that month, ordered by month and then user_id.

Schema

users

Column	Type	Description
user_idPK	INT	Unique SIXT customer identifier
user_name	VARCHAR(100)	Customer display name

rentals

Column	Type	Description
rental_idPK	INT	Unique rental identifier
user_id	INT	Customer who made the rental
rented_at	TIMESTAMP	Timestamp when the car was rented

Your question is SQL for Rental Frequency. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem