HoW MANY employees have the letter z in their first name?
select count ( * ) from employees where first_name like '%z%'
What are their first names?
select first_name from employees where first_name like '%z%'
What about their last names?
select first_name,last_name from employees where first_name like '%z%'
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%'