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

Bar chart x axis location y axis sum total passengers, I want to sort in descending by the Location please.
SELECT Location, SUM(Total_Passengers) FROM station GROUP BY Location ORDER BY Location DESC
SELECT "Location", SUM("Total_Passengers") FROM "station" GROUP BY "Location" ORDER BY "Location" DESC NULLS LAST