Skip to main content
All Problems
easy0% acceptance

High-Value Completed Orders

The finance team is auditing large transactions. Find all orders with a total_amount greater than 500 that have been delivered (status = 'delivered'). Return the order id, order_date, and total_amount.

Schema

🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql

Run your query to see results

Press Ctrl + Enter to execute