How many employees have salary between 100000 and 200000?
SELECT count(*) FROM Employee WHERE salary BETWEEN 100000 AND 200000
employees with salary between 100000 and 200000 refers to salary BETWEEN 100000 AND 200000;