Show me the 10 most recently shipped orders.
select * from shipments order by shipment_date desc limit 10
Ok, show me only the most recent one.
select * from shipments order by shipment_date desc limit 1
Show me its id.
select order_id from shipments where shipment_date = (select max(shipment_date) from shipments)