Find the number of shops in each location.
CREATE TABLE shop (LOCATION VARCHAR)
SELECT COUNT(*), LOCATION FROM shop GROUP BY LOCATION
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE shop (LOCATION VARCHAR) Question: Find the number of shops in each location. [/INST] SELECT COUNT(*), LOCATION FROM shop GROUP BY LOCATION </s>