SELECT e.first name, 1.city, 1.state_province FROM employees e JOIN departments d ON e.department_id = d.department_id JOIN locations 1 ON d.location_id = 1.location_id WHERE e.first_name LIKE %z%'
