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)
CREATE TABLE train_station (Train_ID NUMBER, Station_ID NUMBER)

A bar chart shows how many locations, and sort from high to low by the X.
SELECT Location, COUNT(Location) FROM station GROUP BY Location ORDER BY Location DESC
SELECT "Location", COUNT("Location") FROM "station" GROUP BY "Location" ORDER BY "Location" DESC