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