Drivers Who Didn’t Trip | Dataford Interview Questions

How would you write a SQL query to find drivers who didn’t take a trip in their first 7 days?

Treat the first 7 days as the interval from signup time, inclusive, through signup time plus 7 days, exclusive. Consider only completed trips and exclude drivers whose signup timestamp is unknown.

Output

One row per qualifying driver
Columns: driver_id, signup_at
Include only drivers with no completed trip in the defined interval
Order by driver_id ascending

Schema

drivers

Column	Type	Description
driver_idPK	INT	Unique driver identifier
signup_at	TIMESTAMP	Timestamp when the driver signed up

trips

Column	Type	Description
trip_idPK	INT	Unique trip identifier
driver_id	INT	Driver assigned to the trip
trip_started_at	TIMESTAMP	Timestamp when the trip started
status	VARCHAR(20)	Trip completion status

Your question is Drivers Who Didn’t Trip. 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