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)
CREATE TABLE train (Train_ID INT, Name TEXT, Time TEXT, Service TEXT)
CREATE TABLE train_station (Train_ID INT, Station_ID INT)

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 NULLS LAST