SQL for Renewal Performance | Dataford Interview Questions

Write a SQL query to analyze renewal performance by month, segment, and owner, including conversion rate and churn rate.

Use the provided renewal, account, and owner data. Treat every renewal record as eligible, classify outcomes by status, and preserve renewals whose account or owner is unavailable.

Output

One row per renewal month, segment, and owner.
Columns: renewal_month, segment, owner_name, renewal_count, converted_count, churned_count, conversion_rate, and churn_rate.
Rates are percentages rounded to two decimal places. Order by month, segment, and owner name ascending.

Schema

renewal_opportunities

Column	Type	Description
renewal_idPK	INT	Unique renewal record identifier
account_id	INT	Renewing account identifier
owner_id	INT	Account owner identifier
renewal_date	DATE	Scheduled renewal date
status	VARCHAR(20)	Renewal outcome

accounts

Column	Type	Description
account_idPK	INT	Unique account identifier
account_name	VARCHAR(100)	Customer account name
segment	VARCHAR(30)	Customer segment

owners

Column	Type	Description
owner_idPK	INT	Unique owner identifier
owner_name	VARCHAR(100)	Renewal owner name
team	VARCHAR(50)	Owner team

Your question is SQL for Renewal Performance. 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