What nations are there?
select nationality from ship
How many ships are there?
select count(*) from ship
How many ships does each nation have?
select nationality, count(*) from ship group by nationality
Show me nations that have more than two ships.
select nationality from ship group by nationality having count(*) > 2