How many departments are there?
select count(*) from department
How many departments are led by heads who are mentioned in the database?
select count(*) from department where department_id in (select department_id from management);
How many departments are led by heads who are not mentioned?
select count(*) from department where department_id not in (select department_id from management);