How many employees report to Nancy Edwards?
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"
Who does not report to Nancy Edwards?
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"
Who does Andrew Adams report to?
select t1.first_name, t1.last_name from employees as t1 join employees as t2 on t1.id = t2.reports_to where t2.first_name = "Andrew" and t2.last_name = "Adams"
Who else reports to Andrew Adams?
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 = "Andrew" and t1.last_name = "Adams" and t2.first_name ! = 'Nancy' and t2.last_name ! = 'Edwards'