What is the shipment id for the shipment with this shipment date?
SELECT shipment_id FROM shipments WHERE shipment_date  =   ( SELECT max ( shipment_date )  FROM shipments ) 
shipment id for the shipment with this shipment date refers to selecting shipment_id where shipment_date is the latest (MAX(shipment_date)) among all entries.