Can you also show their cities?
SELECT T1.first_name ,  T1.last_name ,  T3.city FROM employees AS T1 JOIN departments AS T2 ON T1.department_id   =   T2.department_id JOIN locations AS T3 ON T2.location_id   =   T3.location_id WHERE T1.first_name LIKE '%z%'
showing employee's first name, last name, and their city involves joining the employees, departments, and locations tables; filtering employees whose first name contains 'z' is achieved with WHERE T1.first_name LIKE '%z%';