What is the number of employees that have a salary between 100000 and 200000?
select count(*) from employee where salary between 100000 and 200000