Fulfillment Performance SQL | Dataford Interview Questions

Write a SQL query to analyze fulfillment performance by region, including order volume, shipping cost, and average processing time for Shipmonk.

Use the provided tables and analyze non-cancelled orders placed during January 2025. Include regions with no qualifying orders, and ignore missing processing timestamps when calculating the average.

Output

One row per region with region_name, order_volume, total_shipping_cost, and avg_processing_hours.
Include all regions, use zero shipping cost for regions without shipments, and sort by order_volume descending, then region_name ascending.

Schema

regions

Column	Type	Description
region_idPK	INT	Unique region identifier
region_name	VARCHAR(50)	Shipmonk operating region name

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
region_id	INT	Region responsible for fulfillment
created_at	TIMESTAMP	Timestamp when the order was created
processed_at	TIMESTAMP	Timestamp when fulfillment processing completed
status	VARCHAR(20)	Order fulfillment status

shipments

Column	Type	Description
shipment_idPK	INT	Unique shipment identifier
order_id	INT	Order associated with the shipment
shipping_cost	DECIMAL(10,2)	Cost of the shipment

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