What are the name of the employees that do not manage any other employees?
select first_name, last_name from employees where id in (select id from employees except select reports_to from employees)
Show me all the names of all the others!
select t2.first_name, t2.last_name, count(t1.reports_to) from employees as t1 join employees as t2 on t1.reports_to = t2.id;
Who manages the max number of people?
select t2.first_name, t2.last_name from employees as t1 join employees as t2 on t1.reports_to = t2.id group by t1.reports_to order by count(t1.reports_to) desc limit 1;
Also provide the number of people managed!
select t2.first_name, t2.last_name, count(t1.reports_to) from employees as t1 join employees as t2 on t1.reports_to = t2.id group by t1.reports_to order by count(t1.reports_to) desc limit 1;