Skip to main content
All Problems
medium0% acceptance

Average Days to Ship by Status

Calculate the average number of days between order_date and shipping_date for each order status. Only consider orders that have a shipping record. Return the order status, average days to ship (rounded to 1 decimal), and the count of orders.

Schema

🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute