what are the names and classes of the ships that do not have any captain yet?
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 name, class FROM ship WHERE NOT ship_id IN (SELECT ship_id FROM captain)
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: what are the names and classes of the ships that do not have any captain yet? ### 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 name, class FROM ship WHERE NOT ship_id IN (SELECT ship_id FROM captain)