SQL for Monthly Performance Metrics | Dataford Interview Questions

Write a SQL query to analyze monthly operational performance at Buyers Edge Platform by joining orders, customers, and support tickets, then calculate key metrics such as order volume, ticket rate, and average resolution time.

Use the provided tables and return one row per month. Include only months with at least one valid order.

Output

Columns: month, order_volume, active_customer_count, ticket_count, ticket_rate_pct, and avg_resolution_hours
Ticket rate is tickets divided by orders, expressed as a percentage. Exclude unresolved tickets from average resolution time.
Sort chronologically by month.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer business name
region	VARCHAR(50)	Customer operating region

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
customer_id	INT	Customer placing the order
order_date	DATE	Date the order was placed
order_amount	NUMERIC(12,2)	Order value

support_tickets

Column	Type	Description
ticket_idPK	INT	Unique support ticket identifier
customer_id	INT	Customer associated with the ticket
created_at	TIMESTAMP	Ticket creation timestamp
resolved_at	TIMESTAMP	Ticket resolution timestamp
ticket_category	VARCHAR(50)	Support issue category
status	VARCHAR(20)	Current ticket status

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