show all train numbers and names ordered by their time from early to late.
CREATE TABLE route (
    train_id number,
    station_id number
)

CREATE TABLE weekly_weather (
    station_id number,
    day_of_week text,
    high_temperature number,
    low_temperature number,
    precipitation number,
    wind_speed_mph number
)

CREATE TABLE train (
    id number,
    train_number number,
    name text,
    origin text,
    destination text,
    time text,
    interval text
)

CREATE TABLE station (
    id number,
    network_name text,
    services text,
    local_authority text
)
SELECT train_number, name FROM train ORDER BY time
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 all train numbers and names ordered by their time from early to late. ### Input: CREATE TABLE route (
    train_id number,
    station_id number
)

CREATE TABLE weekly_weather (
    station_id number,
    day_of_week text,
    high_temperature number,
    low_temperature number,
    precipitation number,
    wind_speed_mph number
)

CREATE TABLE train (
    id number,
    train_number number,
    name text,
    origin text,
    destination text,
    time text,
    interval text
)

CREATE TABLE station (
    id number,
    network_name text,
    services text,
    local_authority text
) ### Response: SELECT train_number, name FROM train ORDER BY time