Can I have the dates for all the shipments?
select shipment_date from shipments
Which of these dates occurred most recently?
select shipment_date from shipments order by shipment_date desc limit 1
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 )