SQL Top Customers by Shipment Volume | Dataford Interview Questions

Write a SQL query to find the top 5 customers by total shipment volume in the last 90 days at DHL Supply Chain.

Use the customers and shipments tables. Treat the 90-day period as beginning 90 days before the current date.

Output

One row per customer with customer_id, customer_name, and total_shipment_volume.
Include only qualifying shipments from the last 90 days, order by total volume descending, and use customer_id ascending to break ties.
Return only five rows.

customers

Column	Type	Description
customer_idPK	INT	Unique DHL Supply Chain customer identifier
customer_name	VARCHAR(150)	Customer account name

shipments

Column	Type	Description
shipment_idPK	INT	Unique shipment identifier
customer_id	INT	Customer associated with the shipment
shipment_date	DATE	Date the shipment was recorded
shipment_volume	NUMERIC(12,2)	Shipment volume in cubic metres

Your question is SQL Top Customers by Shipment Volume. Start with the requirements and the two 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.