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

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"