The logistics team wants to know how many orders have been successfully delivered. Write a query that returns the total number of orders with a status of 'delivered'.
Schema
🔑idINT
🔗customer_idINT
order_dateTEXT
statusTEXT
total_amountREAL
postgresql
Run your query to see results
Press Ctrl + Enter to execute