CREATE TABLE shipments (order_id VARCHAR2, shipment_date NUMBER)

Find the id of the order which is shipped most recently.
SELECT order_id FROM shipments WHERE shipment_date = (SELECT MAX(shipment_date) FROM shipments)
SELECT "order_id" FROM "shipments" WHERE "shipment_date" = (SELECT MAX("shipment_date") FROM "shipments")