Monthly Active Members Query | Dataford Interview Questions

Write a SQL query to calculate the monthly active members who completed at least five workouts in the last 30 days for Peloton interactive.

Use the members and workouts tables. Treat a member as active when their membership status is active, and count only workouts with status completed. For each calendar month, evaluate the 30-day period ending on the last day of that month.

Output

One row per calendar month, including months with zero qualifying members
Columns: month and active_member_count
Format month as YYYY-MM and order chronologically

Schema

members

Column	Type	Description
member_idPK	INT	Unique Peloton member identifier
member_name	VARCHAR(100)	Member display name
membership_status	VARCHAR(20)	Current membership status

workouts

Column	Type	Description
workout_idPK	INT	Unique workout identifier
member_id	INT	Member who performed the workout
completed_at	TIMESTAMP	Workout completion timestamp
workout_status	VARCHAR(20)	Workout lifecycle status

Your question is Monthly Active Members Query. 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