Database: customers_and_orders
Question: Show all order status and the number of orders in each status.
SQL:
SELECT order_status_code ,  count(*) FROM Customer_orders GROUP BY order_status_code