-- Database schema
| Customers : customer_id [ INT ] primary_key , customer_name [ TEXT ] , customer_details [ TEXT ] | Invoices : invoice_number [ INT ] primary_key , invoice_date [ TEXT ] , invoice_details [ TEXT ] | Orders : order_id [ INT ] primary_key , customer_id [ INT ] Orders.customer_id = Customers.customer_id , order_status [ TEXT ] , date_order_placed [ TEXT ] , order_details [ TEXT ] | Products : product_id [ INT ] primary_key , product_name [ TEXT ] , product_details [ TEXT ] | Order_Items : order_item_id [ INT ] primary_key , product_id [ INT ] Order_Items.product_id = Products.product_id , order_id [ INT ] Order_Items.order_id = Orders.order_id , order_item_status [ TEXT ] , order_item_details [ TEXT ] | Shipments : shipment_id [ INT ] primary_key , order_id [ INT ] Shipments.order_id = Orders.order_id , invoice_number [ INT ] Shipments.invoice_number = Invoices.invoice_number , shipment_tracking_number [ TEXT ] , shipment_date [ TEXT ] , other_shipment_details [ TEXT ] | Shipment_Items : shipment_id [ INT ] Shipment_Items.shipment_id = Shipments.shipment_id , order_item_id [ INT ] Shipment_Items.order_item_id = Order_Items.order_item_id |
-- -- List the ids of all distinct orders ordered by placed date.

SELECT DISTINCT order_id FROM orders ORDER BY date_order_placed;