what are the employee ids and job titles for employees in department 80?
SELECT T1.employee_id, T2.job_title FROM employees AS T1 JOIN jobs AS T2 ON T1.job_id = T2.job_id WHERE T1.department_id = 80
``` yaml
jobs: # name of dataframe
- JOB_ID:
    dtype: string
    sample_values: AD_PRES, AD_VP, AD_ASST
- JOB_TITLE:
    dtype: string
    sample_values: President, Administration Vice President, Administration Assistant
- MIN_SALARY:
    dtype: int64
    sample_values: 20000, 15000, 3000
- MAX_SALARY:
    dtype: int64
    sample_values: 40000, 30000, 6000

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 'job_id' in dataframe 'employees' has a foreign key relation to column 'job_id' in dataframe 'jobs'.

EMPLOYEE_ID,JOB_TITLE
145,Sales Manager
146,Sales Manager
147,Sales Manager
148,Sales Manager
149,Sales Manager
150,Sales Representative
151,Sales Representative
152,Sales Representative
153,Sales Representative
154,Sales Representative
155,Sales Representative
156,Sales Representative
157,Sales Representative
158,Sales Representative
159,Sales Representative
160,Sales Representative
161,Sales Representative
162,Sales Representative
163,Sales Representative
164,Sales Representative
165,Sales Representative
166,Sales Representative
167,Sales Representative
168,Sales Representative
169,Sales Representative
170,Sales Representative
171,Sales Representative
172,Sales Representative
173,Sales Representative
174,Sales Representative
175,Sales Representative
176,Sales Representative
177,Sales Representative
179,Sales Representative
