How many employees serve at least 10 customers?
select count ( * ) from customer as t1 join employee as t2 on t1.supportrepid = t2.employeeid group by t1.supportrepid having count ( * ) > = 10
What are the first names of employees that serve at least 10 customers?
select t1.firstname from customer as t1 join employee as t2 on t1.supportrepid = t2.employeeid group by t1.supportrepid having count ( * ) > = 10
Yes
select company from customer where firstname = "Diego"