CREATE TABLE railway (LOCATION VARCHAR2)

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"