CREATE TABLE route (train_id NUMBER, station_id NUMBER)
CREATE TABLE station (id NUMBER, network_name CLOB, services CLOB, local_authority CLOB)
CREATE TABLE train (id NUMBER, train_number NUMBER, name CLOB, origin CLOB, destination CLOB, time CLOB, interval CLOB)
CREATE TABLE weekly_weather (station_id NUMBER, day_of_week CLOB, high_temperature NUMBER, low_temperature NUMBER, precipitation FLOAT, wind_speed_mph NUMBER)

Bar graph to show the average of high temperature from different day of week, I want to rank by the bars from low to high.
SELECT day_of_week, AVG(high_temperature) FROM weekly_weather GROUP BY day_of_week ORDER BY day_of_week
SELECT "day_of_week", AVG("high_temperature") FROM "weekly_weather" GROUP BY "day_of_week" ORDER BY "day_of_week"