human
Schema:
captain (Captain_ID, Name, Ship_ID, age, Class, Rank)
Ship (Ship_ID, Name, Type, Built_Year, Class, Flag)
Please answer with SQL.
assistant
Sure, I understand.
human
What are the ship id of HM Cutter Avenger?
assistant
SELECT ship_id FROM ship WHERE name = 'HM Cutter Avenger';
human
what type of Flag is used by HMS Manxman?
assistant
SELECT Flag FROM ship WHERE name = "HMS Manxman" ;