Who are the sales representatives in New York City? List their full names.
New York City refers to city = 'NYC'; sales representative refers to jobTitle = 'Sales Rep';
SELECT t1.lastName, t1.firstName FROM employees AS t1 INNER JOIN offices AS t2 ON t1.officeCode = t2.officeCode WHERE t2.city = 'NYC' AND t1.jobTitle = 'Sales Rep'