Database: railway
Question: Show different locations of railways along with the corresponding number of railways at each location.
SQL:
SELECT LOCATION ,  COUNT(*) FROM railway GROUP BY LOCATION