what are the names and classes of the ships that do not have any captain yet?
SELECT name ,  CLASS FROM ship WHERE ship_id NOT IN  ( SELECT ship_id FROM captain ) 
ships that do not have any captain yet refers to selecting ship_id that is NOT IN the captain table; names and classes of the ships refers to selecting name and CLASS from ship table;