Find the number of employees whose title is IT Staff from each city?
CREATE TABLE employees (city VARCHAR, title VARCHAR)
SELECT COUNT(*), city FROM employees WHERE title = 'IT Staff' GROUP BY city
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE employees (city VARCHAR, title VARCHAR) Question: Find the number of employees whose title is IT Staff from each city? [/INST] SELECT COUNT(*), city FROM employees WHERE title = 'IT Staff' GROUP BY city </s>