Model Conversion Rate in SQL | Dataford Interview Questions

Given a table of candidate applications with application_date, status, and region, write a SQL query to find the conversion rate from application to hire by month and region. Use the candidate_applications table. Treat applications with status = 'hired' as hires and exclude rows without an application date.

Output

One row per month and region, including regions with no hires.
Columns: month, region, application_count, hire_count, and conversion_rate, where conversion_rate is the hire percentage rounded to two decimal places.
Order by month ascending, then region ascending, with NULL regions last.

Schema

candidate_applications

Column	Type	Description
application_idPK	INT	Unique identifier for the application
application_date	DATE	Date the candidate submitted the application
status	VARCHAR(30)	Current application status
region	VARCHAR(50)	Candidate application region

Your question is Model Conversion Rate in SQL. Start with the requirements and the one table 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

Output

One row per month and region, including regions with no hires.
Columns: month, region, application_count, hire_count, and conversion_rate, where conversion_rate is the hire percentage rounded to two decimal places.
Order by month ascending, then region ascending, with NULL regions last.

Schema

candidate_applications

Column	Type	Description
application_idPK	INT	Unique identifier for the application
application_date	DATE	Date the candidate submitted the application
status	VARCHAR(30)	Current application status
region	VARCHAR(50)	Candidate application region

Your question is Model Conversion Rate in SQL. Start with the requirements and the one table 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.