give me the ship id
SELECT t1.Ship_ID FROM ship AS t1 JOIN captain AS t2 ON t1.ship_id   =   t2.ship_id WHERE t2.rank   =   'Lieutenant'
ship id refers to Ship_ID; condition based on captain's rank being 'Lieutenant' involves joining tables ship and captain on ship_id and filtering where rank = 'Lieutenant';