How many ships does United Kingdom have?
select nationality,count ( * ) from ship where nationality = 'United Kingdom' group by nationality
Which other country has more than 2 ships?
select nationality from ship where nationality ! = 'United Kingdom' group by nationality having count ( * ) > 2
What type of ships does United States have?
select distinct type from ship where nationality = 'United States'
What about United Kingdom's type of ships?
select distinct type from ship where nationality = 'United Kingdom'