Schema: CREATE TABLE shipments (order_id VARCHAR, shipment_date INTEGER)
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)