Show the total number of employees.
select count(*) from employee
How many of them have a salary between 100000 and 200000?
select count(*) from employee where salary between 100000 and 200000