This problem requires a Pro subscription. Upgrade to access all 15 industry domains and 1,500+ questions.
Upgrade to ProYou are a Carrier Compliance Manager at DHL. The vendor management team needs a report showing which carriers are delivering late most often, and by how much. A delivery is late when the shipment's delivery_date exceeds the order's promised_date. For each carrier, compute the total number of delivered shipments, the count of late deliveries, and the average delay (in days) for only the late ones.
You are a Carrier Compliance Manager at DHL. The vendor management team needs a report showing which carriers are delivering late most often, and by how much. A delivery is late when the shipment's delivery_date exceeds the order's promised_date. For each carrier, compute the total number of delivered shipments, the count of late deliveries, and the average delay (in days) for only the late ones.