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

Show the total number of platforms of locations in each location in a bar chart.
SELECT Location, SUM(Number_of_Platforms) FROM station GROUP BY Location
SELECT "Location", SUM("Number_of_Platforms") FROM "station" GROUP BY "Location"