How many employees are there?
select count ( * ) from employees
Which of the role codes has the most employees?
select role_code from employees group by role_code order by count ( * ) desc limit 1
How many employees does role code ED have?
select count ( * ) from employees where role_code = "ED"