How many employees have salary between 100000 and 200000?
CREATE TABLE Employee (salary INTEGER)
SELECT COUNT(*) FROM Employee WHERE salary BETWEEN 100000 AND 200000
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Employee (salary INTEGER) Question: How many employees have salary between 100000 and 200000? [/INST] SELECT COUNT(*) FROM Employee WHERE salary BETWEEN 100000 AND 200000 </s>