Database: ship_1
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'