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