Show the types of ships that have both ships with tonnage larger than 6000 and ships with tonnage smaller than 4000.
CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    nationality text,
    tonnage number
)

CREATE TABLE mission (
    mission_id number,
    ship_id number,
    code text,
    launched_year number,
    location text,
    speed_knots number,
    fate text
)
SELECT type FROM ship WHERE tonnage > 6000 INTERSECT SELECT type FROM ship WHERE tonnage < 4000
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: Show the types of ships that have both ships with tonnage larger than 6000 and ships with tonnage smaller than 4000. ### Input: CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    nationality text,
    tonnage number
)

CREATE TABLE mission (
    mission_id number,
    ship_id number,
    code text,
    launched_year number,
    location text,
    speed_knots number,
    fate text
) ### Response: SELECT type FROM ship WHERE tonnage > 6000 INTERSECT SELECT type FROM ship WHERE tonnage < 4000