Database: e_commerce
Question: What are the dates of the earliest order and the dates of all orders with more than 1 item?
SQL:
SELECT min(date_order_placed) FROM Orders UNION SELECT T1.date_order_placed FROM Orders AS T1 JOIN Order_items AS T2 ON T1.order_id  =  T2.order_id GROUP BY T1.order_id HAVING count(*)  >  1