Skip to main content
All Problems
hard0% acceptance

Average Delivery Time by Carrier

The logistics team wants to compare carrier performance. Calculate the average number of days between order_date and delivery_date for each carrier, but only for delivered shipments. Return the carrier, total delivered shipments, and average delivery days (rounded to 1 decimal).

Schema

🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute