CREATE TABLE ship (ship_id DECIMAL, name TEXT, type TEXT, nationality TEXT, tonnage DECIMAL)
CREATE TABLE mission (mission_id DECIMAL, ship_id DECIMAL, code TEXT, launched_year DECIMAL, location TEXT, speed_knots DECIMAL, fate TEXT)

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