What are the ship id of HM Cutter Avenger?
select ship_id from ship where name = "HM cutter Avenger"
what type of Flag is used by HMS Manxman?
select flag from ship where name = "HMS Manxman"
what are the Built Year of HMS Gorgon?
select built_year from ship where name = "HMS Gorgon"
Find the ship type that are used by both ships with Panama and Malta flags?
select type from ship where flag = 'Panama' intersect select type from ship where flag = 'Malta'