What are the full names and cities of employees who have the letter Z in their first names?
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%'
``` yaml
departments: # name of dataframe
- DEPARTMENT_ID:
    dtype: int64
    sample_values: 10, 20, 30
- DEPARTMENT_NAME:
    dtype: string
    sample_values: Administration, Marketing, Purchasing
- MANAGER_ID:
    dtype: int64
    sample_values: 200, 201, 114
- LOCATION_ID:
    dtype: int64
    sample_values: 1700, 1800, 1700

employees: # name of dataframe
- EMPLOYEE_ID:
    dtype: int64
    sample_values: 100, 101, 102
- FIRST_NAME:
    dtype: string
    sample_values: Steven, Neena, Lex
- LAST_NAME:
    dtype: string
    sample_values: King, Kochhar, De Haan
- EMAIL:
    dtype: string
    sample_values: SKING, NKOCHHAR, LDEHAAN
- PHONE_NUMBER:
    dtype: string
    sample_values: 515.123.4567, 515.123.4568, 515.123.4569
- HIRE_DATE:
    dtype: datetime
    sample_values: 1987-06-17, 1987-06-18, 1987-06-19
- JOB_ID:
    dtype: string
    sample_values: AD_PRES, AD_VP, AD_VP
- SALARY:
    dtype: int64
    sample_values: 24000, 17000, 17000
- COMMISSION_PCT:
    dtype: float64
    sample_values: 0.0, 0.0, 0.0
- MANAGER_ID:
    dtype: int64
    sample_values: 0, 100, 100
- DEPARTMENT_ID:
    dtype: int64
    sample_values: 90, 90, 90

locations: # name of dataframe
- LOCATION_ID:
    dtype: int64
    sample_values: 1000, 1100, 1200
- STREET_ADDRESS:
    dtype: string
    sample_values: 1297 Via Cola di Rie, 93091 Calle della Testa, 2017 Shinjuku-ku
- POSTAL_CODE:
    dtype: numeric
    sample_values: 989, 10934, 1689
- CITY:
    dtype: string
    sample_values: Roma, Venice, Tokyo
- STATE_PROVINCE:
    dtype: string
    sample_values: ', , Tokyo Prefecture'
- COUNTRY_ID:
    dtype: string
    sample_values: IT, IT, JP

```
Foreign Key constraints:
Column 'department_id' in dataframe 'employees' has a foreign key relation to column 'department_id' in dataframe 'departments'.

FIRST_NAME,LAST_NAME,CITY
Mozhe,Atkinson,South San Francisco
Hazel,Philtanker,South San Francisco
Elizabeth,Bates,OX9 9ZB
