Database: tracking_orders
Question: Which order has the most recent shipment? Give me the order id.
SQL:
SELECT order_id FROM shipments WHERE shipment_date  =  (SELECT max(shipment_date) FROM shipments)