what are the names and classes of the ships that do not have any captain yet?
CREATE TABLE ship (
    name VARCHAR,
    CLASS VARCHAR,
    ship_id VARCHAR
)

CREATE TABLE captain (
    name VARCHAR,
    CLASS VARCHAR,
    ship_id VARCHAR
)
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 ship (
    name VARCHAR,
    CLASS VARCHAR,
    ship_id VARCHAR
)

CREATE TABLE captain (
    name VARCHAR,
    CLASS VARCHAR,
    ship_id VARCHAR
) ### Response: SELECT name, CLASS FROM ship WHERE NOT ship_id IN (SELECT ship_id FROM captain)