SQL for Avg Time Between Purchases | Dataford Interview Questions

Given a table of user transactions at Seatgeek, write a query to find the average time elapsed between a user's first and second ticket purchase.

Use completed ticket purchase timestamps from user_transactions. Users without at least two purchases should not contribute to the average.

Output

user_transactions

Column	Type	Description
transaction_idPK	INT	Unique identifier for the ticket purchase transaction
user_id	INT	SeatGeek user who made the purchase
purchased_at	TIMESTAMPTZ	Timestamp when the ticket purchase occurred

Your question is SQL for Avg Time Between Purchases. Start with the requirements and the one table 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.

Given a table of user transactions at Seatgeek, write a query to find the average time elapsed between a user's first and second ticket purchase.

Use completed ticket purchase timestamps from user_transactions. Users without at least two purchases should not contribute to the average.

user_transactions

Column	Type	Description
transaction_idPK	INT	Unique identifier for the ticket purchase transaction
user_id	INT	SeatGeek user who made the purchase
purchased_at	TIMESTAMPTZ	Timestamp when the ticket purchase occurred

Your question is SQL for Avg Time Between Purchases. Start with the requirements and the one table 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.