<s>[INST] Write a SQL code to identify the number of orders for each unique order status (e.g., confirmed, pending, completed).  [/INST] SELECT order_status, COUNT(*) AS total_orders FROM order_transaction.transaction_detail_deprecated GROUP BY order_status; </s>