How many ships are there?
select count(*) from ship
Which of them are from United States?
select * from ship where nationality = "United States"
Show me the distinct fate of missions that involve any of those.
select distinct t1.fate from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id where t2.nationality = "United States"