How many customers does Steve Johnson support?
create table employees (id varchar, first_name varchar, last_name varchar, PRIMARY KEY (id)); create table customers (support_rep_id varchar, PRIMARY KEY (support_rep_id))
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"