List all the locations.
select location from railway
Which ones have more than one railways?
select location from railway group by location having count(*) > 1
Show the locations and the corresponding counts of each.
select location, count(*) from railway group by location