SCHEMA:
CREATE TABLE Employee (salary INTEGER)
USER:
How many employees have salary between 100000 and 200000?

QUERY:
SELECT COUNT(*) FROM Employee WHERE salary BETWEEN 100000 AND 200000