Find the ship type that are used by both ships with Panama and Malta flags.
CREATE TABLE captain (
    captain_id number,
    name text,
    ship_id number,
    age text,
    class text,
    rank text
)

CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    built_year number,
    class text,
    flag text
)
SELECT type FROM ship WHERE flag = 'Panama' INTERSECT SELECT type FROM ship WHERE flag = 'Malta'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the ship type that are used by both ships with Panama and Malta flags. ### Input: CREATE TABLE captain (
    captain_id number,
    name text,
    ship_id number,
    age text,
    class text,
    rank text
)

CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    built_year number,
    class text,
    flag text
) ### Response: SELECT type FROM ship WHERE flag = 'Panama' INTERSECT SELECT type FROM ship WHERE flag = 'Malta'