Show names of ships involved in a mission launched after 1928.
CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    nationality text,
    tonnage number
)

CREATE TABLE mission (
    mission_id number,
    ship_id number,
    code text,
    launched_year number,
    location text,
    speed_knots number,
    fate text
)
SELECT T2.name FROM mission AS T1 JOIN ship AS T2 ON T1.ship_id = T2.ship_id WHERE T1.launched_year > 1928
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Show names of ships involved in a mission launched after 1928. ### Input: CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    nationality text,
    tonnage number
)

CREATE TABLE mission (
    mission_id number,
    ship_id number,
    code text,
    launched_year number,
    location text,
    speed_knots number,
    fate text
) ### Response: SELECT T2.name FROM mission AS T1 JOIN ship AS T2 ON T1.ship_id = T2.ship_id WHERE T1.launched_year > 1928