How many sales representitives are based in the offices in the USA?
Sales representative refers to jobTitle = 'Sales Rep'; country = 'USA';
SELECT COUNT(t1.employeeNumber) FROM employees AS t1 INNER JOIN offices AS t2 ON t1.officeCode = t2.officeCode WHERE t2.country = 'USA' AND t1.jobTitle = 'Sales Rep'