CREATE TABLE ship (name VARCHAR(255), CLASS VARCHAR(255), ship_id VARCHAR(255)); CREATE TABLE captain (name VARCHAR(255), CLASS VARCHAR(255), ship_id VARCHAR(255))
what are the names and classes of the ships that do not have any captain yet?
    
SQL: SELECT name, CLASS FROM ship WHERE NOT ship_id IN (SELECT ship_id FROM captain)