SQL for Sales Performance | Dataford Interview Questions

Write a SQL query to analyze sales performance by region and month at Twilio, joining opportunities, accounts, and rep tables and calculating conversion rate.

Use all available opportunity records whose account and assigned rep can be matched. Treat opportunities with a Closed Won stage as converted.

Output

One row per region and calendar month.
Columns: region, month, total_opportunities, won_opportunities, and conversion_rate.
Return the conversion rate as won opportunities divided by total opportunities, rounded to four decimal places.
Order by region, then month ascending.

Schema

opportunities

Column	Type	Description
opportunity_idPK	INT	Unique opportunity identifier
account_id	INT	Account associated with the opportunity
created_at	DATE	Opportunity creation date
stage	VARCHAR(30)	Current sales stage
amount	NUMERIC(12,2)	Opportunity value

accounts

Column	Type	Description
account_idPK	INT	Unique customer account identifier
account_name	VARCHAR(120)	Customer account name
region	VARCHAR(30)	Sales region for the account
rep_id	INT	Assigned sales representative

reps

Column	Type	Description
rep_idPK	INT	Unique sales representative identifier
rep_name	VARCHAR(100)	Sales representative name
team	VARCHAR(50)	Representative team

Your question is SQL for Sales 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