What is the title of Nancy Edwards?
select title from employees where first_name = "Nancy" and last_name = "Edwards";
Who does she report to?
select t2.first_name, t2.last_name from employees as t1 join employees as t2 on t1.reports_to = t2.id where t1.first_name = "Nancy" and t1.last_name = "Edwards";
How many report to her?
select count(*) from employees as t1 join employees as t2 on t1.id = t2.reports_to where t1.first_name = "Nancy" and t1.last_name = "Edwards";
What are their names?
select t2.first_name, t2.last_name from employees as t1 join employees as t2 on t1.id = t2.reports_to where t1.first_name = "Nancy" and t1.last_name = "Edwards";