Skip to main content
All Problems
easy0% acceptance

Pending and Processing Orders

Customer support needs a list of all orders that are still in progress. Retrieve the order id, customer_id, order_date, and status for orders whose status is either 'pending' or 'processing', sorted 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