Cohort Driver Activity Query | Dataford Interview Questions

Identify all Lyft drivers who completed at least ten trips in their first week but did not complete any trips in their second week.

Use each driver's onboarded_at timestamp as the start of week one. Count completed trips from the first seven days and the following seven days.

Output

One row per qualifying driver with driver_id, driver_name, and first_week_trips.
Include only drivers with at least 10 first-week trips and zero second-week trips.
Order by driver_id ascending.

drivers

Column	Type	Description
driver_idPK	INT	Unique Lyft driver identifier
driver_name	VARCHAR(100)	Driver display name
onboarded_at	TIMESTAMP	Timestamp when the driver became active

trips

Column	Type	Description
trip_idPK	INT	Unique trip identifier
driver_id	INT	Driver assigned to the trip
status	VARCHAR(20)	Trip lifecycle status
completed_at	TIMESTAMP	Timestamp when the trip was completed

Your question is Cohort Driver Activity 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.