Skip to main content
All Problems
medium0% acceptance

Orders That Were Never Shipped

Find all orders that have no corresponding shipping record. Return the order id, customer_id, order_date, status, and total_amount. Sort by order_date descending.

Schema

🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute