How many employees does each department have?
select num_employees from department
What is the number of employees of the departments whose rank is between 10 and 15?
select num_employees from department where ranking between 10 and 15
What is the average number of employees of these departments?
select avg(num_employees) from department where ranking between 10 and 15