Show me the name of all the ships.
select name from ship
Which of them belong to United states?
select name from ship where nationality = "United States"
Include those that belong to United Kingdom.
select name from ship where nationality = "United States" or nationality = "United Kingdom"