SQL for Avg Time Between Purchases

MediumSQL · PostgreSQL

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

Tablesuser_transactions

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.