Display the first name and department name for each employee.
SELECT T1.first_name, T2.department_name FROM employees AS T1 JOIN departments AS T2 ON T1.department_id = T2.department_id
``` 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

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

FIRST_NAME,DEPARTMENT_NAME
Steven,Executive
Neena,Executive
Lex,Executive
Alexander,IT
Bruce,IT
David,IT
Valli,IT
Diana,IT
Nancy,Finance
Daniel,Finance
John,Finance
Ismael,Finance
Jose Manuel,Finance
Luis,Finance
Den,Purchasing
Alexander,Purchasing
Shelli,Purchasing
Sigal,Purchasing
Guy,Purchasing
Karen,Purchasing
Matthew,Shipping
Adam,Shipping
Payam,Shipping
Shanta,Shipping
Kevin,Shipping
Julia,Shipping
Irene,Shipping
James,Shipping
Steven,Shipping
Laura,Shipping
Mozhe,Shipping
James,Shipping
TJ,Shipping
Jason,Shipping
Michael,Shipping
Ki,Shipping
Hazel,Shipping
Renske,Shipping
Stephen,Shipping
John,Shipping
Joshua,Shipping
Trenna,Shipping
Curtis,Shipping
Randall,Shipping
Peter,Shipping
John,Sales
Karen,Sales
Alberto,Sales
Gerald,Sales
Eleni,Sales
Peter,Sales
David,Sales
Peter,Sales
Christopher,Sales
Nanette,Sales
Oliver,Sales
Janette,Sales
Patrick,Sales
Allan,Sales
Lindsey,Sales
Louise,Sales
Sarath,Sales
Clara,Sales
Danielle,Sales
Mattea,Sales
David,Sales
Sundar,Sales
Amit,Sales
Lisa,Sales
Harrison,Sales
Tayler,Sales
William,Sales
Elizabeth,Sales
Sundita,Sales
Ellen,Sales
Alyssa,Sales
Jonathon,Sales
Jack,Sales
Charles,Sales
Winston,Shipping
Jean,Shipping
Martha,Shipping
Girard,Shipping
Nandita,Shipping
Alexis,Shipping
Julia,Shipping
Anthony,Shipping
Kelly,Shipping
Jennifer,Shipping
Timothy,Shipping
Randall,Shipping
Sarah,Shipping
Britney,Shipping
Samuel,Shipping
Vance,Shipping
Alana,Shipping
Kevin,Shipping
Donald,Shipping
Douglas,Shipping
Jennifer,Administration
Michael,Marketing
Pat,Marketing
Susan,Human Resources
Hermann,Public Relations
Shelley,Accounting
William,Accounting
