Skip to main content
All Problems
medium0% acceptance

Orders with Shipping Delays

Find orders where shipping took longer than 3 days (from order_date to shipping_date). Return the order id, order_date, shipping_date, and the number of days to ship as days_to_ship. Sort by delay descending.

Schema

🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute