CREATE TABLE train_station (train_id DECIMAL, station_id DECIMAL)
CREATE TABLE station (station_id DECIMAL, name TEXT, annual_entry_exit DECIMAL, annual_interchanges DECIMAL, total_passengers DECIMAL, location TEXT, main_services TEXT, number_of_platforms DECIMAL)
CREATE TABLE train (train_id DECIMAL, name TEXT, time TEXT, service TEXT)

Show all locations and the total number of platforms and passengers for all train stations in each location.
SELECT location, SUM(number_of_platforms), SUM(total_passengers) FROM station GROUP BY location
SELECT "location", SUM("number_of_platforms"), SUM("total_passengers") FROM "station" GROUP BY "location"