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

Bar graph to show the average of high temperature from different day of week, and rank Y-axis in desc order.
SELECT day_of_week, AVG(high_temperature) FROM weekly_weather GROUP BY day_of_week ORDER BY AVG(high_temperature) DESC
SELECT "day_of_week", AVG("high_temperature") FROM "weekly_weather" GROUP BY "day_of_week" ORDER BY AVG("high_temperature") DESC NULLS LAST