SQL, Graphs, and Stats | Dataford Interview Questions

Tell me about a time you used SQL, graphs, and basic statistics to answer a business question at Booking.

Use the provided Booking search and booking data to demonstrate the SQL portion of your answer. Produce analysis-ready metrics that could support a chart and a concise business interpretation.

Output

One row per month and acquisition channel
Include month, channel, searches, converted_searches, conversion_rate, avg_revenue_per_search, and revenue_stddev
Include channels with no bookings, sort by month ascending and channel ascending, with NULL channels last

Schema

booking_searches

Column	Type	Description
search_idPK	INT	Unique search event identifier
searched_at	TIMESTAMP	Timestamp when the search occurred
channel	VARCHAR(50)	Acquisition channel associated with the search

bookings

Column	Type	Description
booking_idPK	INT	Unique booking identifier
search_id	INT	Search that led to the booking
booking_amount	NUMERIC(10,2)	Booking revenue amount

Your question is SQL, Graphs, and Stats. 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