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)

Show all locations and the total number of platforms for all train stations in each location in a bar chart, sort by the Location in ascending.
SELECT Location, SUM(Number_of_Platforms) FROM station GROUP BY Location ORDER BY Location
SELECT "Location", SUM("Number_of_Platforms") FROM "station" GROUP BY "Location" ORDER BY "Location"