SQL Problem Solving | Dataford Interview Questions

Tell me about a time you were asked to solve various problems in SQL.

For this exercise, use the provided Insurify-style operational tables and write one query that answers the requested business questions from the same dataset. Keep the result set compact and deterministic.

Output

One row per customer who has at least one completed quote and at least one policy event.
Return customer_id, customer_name, completed_quotes, policy_events, first_completed_quote_date, last_policy_event_date, and days_between_first_and_last.
Include only customers whose completed quotes are greater than zero and whose policy events are greater than zero.
Sort by days_between_first_and_last descending, then customer_id ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(255)	Customer full name
state	VARCHAR(50)	Customer state

quotes

Column	Type	Description
quote_idPK	INT	Unique quote identifier
customer_id	INT	References customers.customer_id
quote_status	VARCHAR(50)	Quote status such as completed or abandoned
quote_created_at	DATE	Date the quote was created

policy_events

Column	Type	Description
event_idPK	INT	Unique policy event identifier
customer_id	INT	References customers.customer_id
event_type	VARCHAR(50)	Policy event type
event_date	DATE	Date of the policy event

Your question is SQL Problem Solving. Start with the requirements and the three 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