Compute Time to First Booking | Dataford Interview Questions

Given a table of Thumbtack customer interactions and service bookings, write a query to find the average time elapsed between a customer's first search and their first confirmed booking.

Include only customers with both events, and exclude confirmed bookings that occurred before the customer's first search.

Output

Return one row with average_elapsed_hours, rounded to two decimal places.
Include only customers meeting the stated event requirements.

Schema

customer_interactions

Column	Type	Description
interaction_idPK	INT	Unique interaction identifier
customer_id	INT	Thumbtack customer identifier
interaction_type	VARCHAR(30)	Interaction type, such as search or view
occurred_at	TIMESTAMP	Timestamp when the interaction occurred

service_bookings

Column	Type	Description
booking_idPK	INT	Unique booking identifier
customer_id	INT	Thumbtack customer identifier
status	VARCHAR(20)	Booking status
booked_at	TIMESTAMP	Timestamp when the booking reached its recorded status

Your question is Compute Time to First Booking. 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