Show different locations of railways along with the corresponding number of railways at each location.
CREATE TABLE railway (LOCATION VARCHAR)
SELECT LOCATION, COUNT(*) FROM railway GROUP BY LOCATION
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE railway (LOCATION VARCHAR) Question: Show different locations of railways along with the corresponding number of railways at each location. [/INST] SELECT LOCATION, COUNT(*) FROM railway GROUP BY LOCATION </s>