Hello! Can you tell me how many total employees are on this list?
select count ( distinct employee_id ) from employees
Oh thanks! You went ahead and added the last name and city!  Could you also add to this list which country each of these people live in?
select t1.first_name, t1.last_name, t3.city ,t3.country_id 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%'
Thanks!  That City and Country ID for Elizabeth is unusual...  Can you please show her street address and state province?
select t1.first_name, t1.last_name, t3.city ,t3.country_id,t3.street_address,t3.state_province 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%' and t1.first_name = 'Elizabeth'