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