What about their last names?
select first_name,last_name from employees where first_name LIKE '%z%'
their last names refers to selecting last_name column; first name containing 'z' refers to first_name LIKE '%z%';