Hello!  How are you!  Can you tell me how many missions there are in total?
select count ( * ) from mission
Great! Can you filter this list to show only the mission that involved ships from the United States?
select t1.fate from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id where t2.nationality = "United States"
Great! Could you update this list to show all of the mission IDs?
select t1.fate, t1.mission_id from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id where t2.nationality = "United States"