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)
[SQL] SELECT LOCATION, SUM(number_of_platforms), SUM(total_passengers) FROM station GROUP BY LOCATION [/SQL]