What are the name of all the ships?
select name from ship
Give me missions that were launched after 1928.
select * from mission where launched_year > 1928
Which ships were involved in any of those?
select t2.name from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id where t1.launched_year > 1928