Show all locations and the total number of platforms and passengers for all train stations in each location.
CREATE TABLE station (LOCATION VARCHAR, number_of_platforms INTEGER, total_passengers INTEGER)
SELECT LOCATION, SUM(number_of_platforms), SUM(total_passengers) FROM station GROUP BY LOCATION
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE station (LOCATION VARCHAR, number_of_platforms INTEGER, total_passengers INTEGER) Question: Show all locations and the total number of platforms and passengers for all train stations in each location. [/INST] SELECT LOCATION, SUM(number_of_platforms), SUM(total_passengers) FROM station GROUP BY LOCATION </s>