display the employee number, name( first name and last name ), and salary for all employees who earn more than the average salary and who work in a department with any employee with a 'J' in their first name.
SELECT employee_id, first_name, last_name, salary FROM employees WHERE salary > (SELECT AVG(salary) FROM employees) AND department_id IN (SELECT department_id FROM employees WHERE first_name LIKE '%J%')
``` yaml
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

```
EMPLOYEE_ID,FIRST_NAME,LAST_NAME,SALARY
108,Nancy,Greenberg,12000
109,Daniel,Faviet,9000
110,John,Chen,8200
111,Ismael,Sciarra,7700
112,Jose Manuel,Urman,7800
113,Luis,Popp,6900
120,Matthew,Weiss,8000
121,Adam,Fripp,8200
122,Payam,Kaufling,7900
123,Shanta,Vollman,6500
145,John,Russell,14000
146,Karen,Partners,13500
147,Alberto,Errazuriz,12000
148,Gerald,Cambrault,11000
149,Eleni,Zlotkey,10500
150,Peter,Tucker,10000
151,David,Bernstein,9500
152,Peter,Hall,9000
153,Christopher,Olsen,8000
154,Nanette,Cambrault,7500
155,Oliver,Tuvault,7000
156,Janette,King,10000
157,Patrick,Sully,9500
158,Allan,McEwen,9000
159,Lindsey,Smith,8000
160,Louise,Doran,7500
161,Sarath,Sewall,7000
162,Clara,Vishney,10500
163,Danielle,Greene,9500
164,Mattea,Marvins,7200
165,David,Lee,6800
168,Lisa,Ozer,11500
169,Harrison,Bloom,10000
170,Tayler,Fox,9600
171,William,Smith,7400
172,Elizabeth,Bates,7300
174,Ellen,Abel,11000
175,Alyssa,Hutton,8800
176,Jonathon,Taylor,8600
177,Jack,Livingston,8400
