First name please.
select first_name from employees
How about their last names?
select last_name from employees
How many last names start with the letter J?
select count ( * ) from employees where last_name like 'J%'
What is that person's first name?
select first_name from employees where last_name like 'J%'
How many customers does he support?
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"