SQL for Operational Comparisons | Dataford Interview Questions

Write a SQL query to compare monthly operational volume, response rates, and delays by region and client, using joins and aggregations.

Use the provided operational request, client, and region data. Include requests with missing responses, calculate response rates as percentages, and calculate average delays only for requests with a response.

Output

One row per month, region, and client.
Columns: month_start, region_name, client_name, operational_volume, responded_volume, response_rate_pct, and average_delay_days.
Include all operational requests with a non-null request date. Sort by month, region, and client.

Schema

regions

Column	Type	Description
region_idPK	INT	Unique region identifier
region_name	VARCHAR(100)	Region name

clients

Column	Type	Description
client_idPK	INT	Unique client identifier
client_name	VARCHAR(150)	Client name
region_id	INT	Client's assigned region

operational_requests

Column	Type	Description
request_idPK	INT	Unique operational request identifier
client_id	INT	Client associated with the request
request_date	DATE	Date the request was received
response_date	DATE	Date the request received a response

Your question is SQL for Operational Comparisons. 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