HoW MANY employees have the letter z in their first name?
select count ( * )  from employees where first_name LIKE '%z%'
employees with the letter z in their first name refers to WHERE first_name LIKE '%z%'; counting these employees refers to COUNT(*)