What is the average number of employees of the departments whose rank is between 10 and 15?
CREATE TABLE department (num_employees INTEGER, ranking INTEGER)
SELECT AVG(num_employees) FROM department WHERE ranking BETWEEN 10 AND 15
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE department (num_employees INTEGER, ranking INTEGER) Question: What is the average number of employees of the departments whose rank is between 10 and 15? [/INST] SELECT AVG(num_employees) FROM department WHERE ranking BETWEEN 10 AND 15 </s>