Database: train_station
Question: Show all locations and the total number of platforms and passengers for all train stations in each location.
SQL:
SELECT LOCATION ,  sum(number_of_platforms) ,  sum(total_passengers) FROM station GROUP BY LOCATION