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