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
Which type of ship has flag Panama?
assistant
SELECT DISTINCT TYPE FROM ship WHERE flag = 'Panama';
human
How about Malta?
assistant
SELECT TYPE FROM ship WHERE flag = "Malta" ;