SELECT LOCATION ,  COUNT(*) FROM railway GROUP BY LOCATION
Show different locations of railways along with the corresponding number of railways at each location.
SELECT LOCATION , COUNT ( * ) FROM railway GROUP BY LOCATION
select location , count ( * ) from railway group by location
Show different locations of railways along with the corresponding number of railways at each location .