CREATE TABLE train (Train_ID NUMBER, Name CLOB, Time CLOB, Service CLOB)
CREATE TABLE train_station (Train_ID NUMBER, Station_ID NUMBER)
CREATE TABLE station (Station_ID NUMBER, Name CLOB, Annual_entry_exit FLOAT, Annual_interchanges FLOAT, Total_Passengers FLOAT, Location CLOB, Main_Services CLOB, Number_of_Platforms NUMBER)

What is the average of number_of_platforms for each location? Show the comparison with a bar chart, could you list x-axis in ascending order?
SELECT Location, AVG(Number_of_Platforms) FROM station GROUP BY Location ORDER BY Location
SELECT "Location", AVG("Number_of_Platforms") FROM "station" GROUP BY "Location" ORDER BY "Location"