Identify the number of orders for each unique order status (e.g., confirmed, pending, completed).

SELECT order_status, COUNT(*) AS total_orders
FROM order_transaction.transaction_detail_deprecated
GROUP BY order_status;