show names of ships involved in a mission launched after 1928.
select t2.name from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id where t1.launched_year > 1928
which ships were lost?
select * from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id where t1.fate like "%lost%"
which among them was the biggest?
select * from mission as t1 join ship as t2 on t1.ship_id = t2.ship_id where t1.fate like "%lost%" order by t2.tonnage desc limit 1