What are the names of all ships?
select name from ship
And what about all the classes?
select class from ship
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 )