Database: tracking_orders
Question: Find the id of the order which is shipped most recently.
SQL:
SELECT order_id FROM shipments WHERE shipment_date  =  (SELECT max(shipment_date) FROM shipments)