Which ship ids are not in the captain records?
select ship_id from ship except select ship_id from captain
Give their names and classes
select name, class from ship where ship_id not in (select ship_id from captain)