How many employees have salary between 100000 and 200000?
select count(*) from employee where salary between 100000 and 200000