Database: ship_1
Question: what are the names and classes of the ships that do not have any captain yet?
SQL:
SELECT name ,  CLASS FROM ship WHERE ship_id NOT IN (SELECT ship_id FROM captain)