Find the ship type that are used by both ships with Panama and Malta flags.
create table ship (type varchar, flag varchar, PRIMARY KEY (type))
select type from ship where flag = 'panama' intersect select type from ship where flag = 'malta'