CREATE TABLE mission (Ship_ID VARCHAR, Launched_Year INT)
CREATE TABLE ship (Name VARCHAR, Ship_ID VARCHAR)

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
SELECT "T2"."Name" FROM "mission" AS "T1" JOIN "ship" AS "T2" ON "T1"."Ship_ID" = "T2"."Ship_ID" WHERE "T1"."Launched_Year" > 1928