Database: e_commerce
Question: For every order, how many products does it contain, and what are the orders' statuses and ids?
SQL:
SELECT T1.order_id ,  T1.order_status_code ,  count(*) FROM Orders AS T1 JOIN Order_items AS T2 ON T1.order_id  =  T2.order_id GROUP BY T1.order_id