SELECT order_id FROM shipments WHERE shipment_date  =  (SELECT max(shipment_date) FROM shipments)
Which order has the most recent shipment? Give me the order id.
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 )
Which order has the most recent shipment ? Give me the order id .