SELECT day_of_week, AVG(high_temperature) FROM weekly_weather GROUP BY day_of_week ORDER BY AVG(high_temperature) DESC
Return a histogram on what is the average high temperature for each day of week?, and show in desc by the y-axis.
CREATE TABLE station (
    id int,
    network_name text,
    services text,
    local_authority text
)

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

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

CREATE TABLE route (
    train_id int,
    station_id int
)