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

What are the mission codes, fates, and names of the ships involved?
SELECT T1.code, T1.fate, T2.name FROM mission AS T1 JOIN ship AS T2 ON T1.ship_id = T2.ship_id
SELECT "T1"."code", "T1"."fate", "T2"."name" FROM "mission" AS "T1" JOIN "ship" AS "T2" ON "T1"."ship_id" = "T2"."ship_id"