What is the title of the employee with first name Steve and last name Johnson?
select title from employees where first_name = "Steve" and last_name = "Johnson";
Who does he 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 = "Steve" and t1.last_name = "Johnson";
What customers does he support?
select t2.first_name, t2.last_name from employees as t1 join customers as t2 on t2.support_rep_id = t1.id where t1.first_name = "Steve" and t1.last_name = "Johnson";
How many are there?
select count(*) from employees as t1 join customers as t2 on t2.support_rep_id = t1.id where t1.first_name = "Steve" and t1.last_name = "Johnson";