Skip to main content
All Problems
easy0% acceptance

Orders by Status

The fulfillment team needs to quickly find all orders that are either 'pending' or 'processing'. Return the order id, customer_id, order_date, and status, ordered by order_date ascending.

Schema

🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute