Schema: CREATE TABLE ship (TYPE VARCHAR, flag VARCHAR)
Question: Find the ship type that are used by both ships with Panama and Malta flags.
SQL: SELECT TYPE FROM ship WHERE flag = 'Panama' INTERSECT SELECT TYPE FROM ship WHERE flag = 'Malta'