Show the names  of all ships from United States?
select name from ship where nationality = "United States"
Show the names of all ships from United Kingdom?
select name from ship where nationality = "United Kingdom"
What type of ship is the Corbridge ?
select type from ship where name = "Corbridge"
What is the tonnage of the Corbridge ?
select tonnage from ship where name = "Corbridge"
What is the name of the ship with 3146 tonnage ?
select name from ship where tonnage = "3146"
What is the name of the ship with the most tonnage ?
select name from ship order by tonnage desc limit 1
How many different types of ships are there ?
select count ( distinct type ) from ship