Can I see list of names and classes of ships that don't have any captain?
SELECT name ,  CLASS FROM ship WHERE ship_id NOT IN  ( SELECT ship_id FROM captain ) 
ships that don't have any captain refers to ships without a corresponding entry in the captain table; list of names and classes of ships refers to selecting the name and class columns from the ship table;