Find the ship type that are used by both ships with Panama and Malta flags.
CREATE TABLE ship (TYPE VARCHAR, flag VARCHAR)
SELECT TYPE FROM ship WHERE flag = 'Panama' INTERSECT SELECT TYPE FROM ship WHERE flag = 'Malta'
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE ship (TYPE VARCHAR, flag VARCHAR) Question: Find the ship type that are used by both ships with Panama and Malta flags. [/INST] SELECT TYPE FROM ship WHERE flag = 'Panama' INTERSECT SELECT TYPE FROM ship WHERE flag = 'Malta' </s>