SELECT name ,  CLASS FROM ship WHERE ship_id NOT IN (SELECT ship_id FROM captain)
Return the names and classes of ships that do not have a captain?
SELECT name , CLASS FROM ship WHERE ship_id NOT IN ( SELECT ship_id FROM captain )
select name , class from ship where ship_id not in ( select ship_id from captain )
Return the names and classes of ships that do not have a captain ?