Find the name, type, and flag of the ship that is built in the most recent year.
CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    built_year number,
    class text,
    flag text
)

CREATE TABLE captain (
    captain_id number,
    name text,
    ship_id number,
    age text,
    class text,
    rank text
)
SELECT name, type, flag FROM ship ORDER BY built_year DESC LIMIT 1
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: Find the name, type, and flag of the ship that is built in the most recent year. ### Input: CREATE TABLE ship (
    ship_id number,
    name text,
    type text,
    built_year number,
    class text,
    flag text
)

CREATE TABLE captain (
    captain_id number,
    name text,
    ship_id number,
    age text,
    class text,
    rank text
) ### Response: SELECT name, type, flag FROM ship ORDER BY built_year DESC LIMIT 1