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)
CREATE TABLE train (Train_ID NUMBER, Name CLOB, Time CLOB, Service CLOB)

Bar graph to show how many location from different location, order in ascending by the X-axis please.
SELECT Location, COUNT(Location) FROM station GROUP BY Location ORDER BY Location
SELECT "Location", COUNT("Location") FROM "station" GROUP BY "Location" ORDER BY "Location"