What are the ids, full names, and salaries for employees making more than average and who work in a department with employees who have the letter 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%')
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%')
[{'EMPLOYEE_ID': 108, 'FIRST_NAME': 'Nancy', 'LAST_NAME': 'Greenberg', 'SALARY': 12000}, {'EMPLOYEE_ID': 109, 'FIRST_NAME': 'Daniel', 'LAST_NAME': 'Faviet', 'SALARY': 9000}, {'EMPLOYEE_ID': 110, 'FIRST_NAME': 'John', 'LAST_NAME': 'Chen', 'SALARY': 8200}, {'EMPLOYEE_ID': 111, 'FIRST_NAME': 'Ismael', 'LAST_NAME': 'Sciarra', 'SALARY': 7700}, {'EMPLOYEE_ID': 112, 'FIRST_NAME': 'Jose Manuel', 'LAST_NAME': 'Urman', 'SALARY': 7800}, {'EMPLOYEE_ID': 113, 'FIRST_NAME': 'Luis', 'LAST_NAME': 'Popp', 'SALARY': 6900}, {'EMPLOYEE_ID': 120, 'FIRST_NAME': 'Matthew', 'LAST_NAME': 'Weiss', 'SALARY': 8000}, {'EMPLOYEE_ID': 121, 'FIRST_NAME': 'Adam', 'LAST_NAME': 'Fripp', 'SALARY': 8200}, {'EMPLOYEE_ID': 122, 'FIRST_NAME': 'Payam', 'LAST_NAME': 'Kaufling', 'SALARY': 7900}, {'EMPLOYEE_ID': 123, 'FIRST_NAME': 'Shanta', 'LAST_NAME': 'Vollman', 'SALARY': 6500}, {'EMPLOYEE_ID': 145, 'FIRST_NAME': 'John', 'LAST_NAME': 'Russell', 'SALARY': 14000}, {'EMPLOYEE_ID': 146, 'FIRST_NAME': 'Karen', 'LAST_NAME': 'Partners', 'SALARY': 13500}, {'EMPLOYEE_ID': 147, 'FIRST_NAME': 'Alberto', 'LAST_NAME': 'Errazuriz', 'SALARY': 12000}, {'EMPLOYEE_ID': 148, 'FIRST_NAME': 'Gerald', 'LAST_NAME': 'Cambrault', 'SALARY': 11000}, {'EMPLOYEE_ID': 149, 'FIRST_NAME': 'Eleni', 'LAST_NAME': 'Zlotkey', 'SALARY': 10500}, {'EMPLOYEE_ID': 150, 'FIRST_NAME': 'Peter', 'LAST_NAME': 'Tucker', 'SALARY': 10000}, {'EMPLOYEE_ID': 151, 'FIRST_NAME': 'David', 'LAST_NAME': 'Bernstein', 'SALARY': 9500}, {'EMPLOYEE_ID': 152, 'FIRST_NAME': 'Peter', 'LAST_NAME': 'Hall', 'SALARY': 9000}, {'EMPLOYEE_ID': 153, 'FIRST_NAME': 'Christopher', 'LAST_NAME': 'Olsen', 'SALARY': 8000}, {'EMPLOYEE_ID': 154, 'FIRST_NAME': 'Nanette', 'LAST_NAME': 'Cambrault', 'SALARY': 7500}, {'EMPLOYEE_ID': 155, 'FIRST_NAME': 'Oliver', 'LAST_NAME': 'Tuvault', 'SALARY': 7000}, {'EMPLOYEE_ID': 156, 'FIRST_NAME': 'Janette', 'LAST_NAME': 'King', 'SALARY': 10000}, {'EMPLOYEE_ID': 157, 'FIRST_NAME': 'Patrick', 'LAST_NAME': 'Sully', 'SALARY': 9500}, {'EMPLOYEE_ID': 158, 'FIRST_NAME': 'Allan', 'LAST_NAME': 'McEwen', 'SALARY': 9000}, {'EMPLOYEE_ID': 159, 'FIRST_NAME': 'Lindsey', 'LAST_NAME': 'Smith', 'SALARY': 8000}, {'EMPLOYEE_ID': 160, 'FIRST_NAME': 'Louise', 'LAST_NAME': 'Doran', 'SALARY': 7500}, {'EMPLOYEE_ID': 161, 'FIRST_NAME': 'Sarath', 'LAST_NAME': 'Sewall', 'SALARY': 7000}, {'EMPLOYEE_ID': 162, 'FIRST_NAME': 'Clara', 'LAST_NAME': 'Vishney', 'SALARY': 10500}, {'EMPLOYEE_ID': 163, 'FIRST_NAME': 'Danielle', 'LAST_NAME': 'Greene', 'SALARY': 9500}, {'EMPLOYEE_ID': 164, 'FIRST_NAME': 'Mattea', 'LAST_NAME': 'Marvins', 'SALARY': 7200}, {'EMPLOYEE_ID': 165, 'FIRST_NAME': 'David', 'LAST_NAME': 'Lee', 'SALARY': 6800}, {'EMPLOYEE_ID': 168, 'FIRST_NAME': 'Lisa', 'LAST_NAME': 'Ozer', 'SALARY': 11500}, {'EMPLOYEE_ID': 169, 'FIRST_NAME': 'Harrison', 'LAST_NAME': 'Bloom', 'SALARY': 10000}, {'EMPLOYEE_ID': 170, 'FIRST_NAME': 'Tayler', 'LAST_NAME': 'Fox', 'SALARY': 9600}, {'EMPLOYEE_ID': 171, 'FIRST_NAME': 'William', 'LAST_NAME': 'Smith', 'SALARY': 7400}, {'EMPLOYEE_ID': 172, 'FIRST_NAME': 'Elizabeth', 'LAST_NAME': 'Bates', 'SALARY': 7300}, {'EMPLOYEE_ID': 174, 'FIRST_NAME': 'Ellen', 'LAST_NAME': 'Abel', 'SALARY': 11000}, {'EMPLOYEE_ID': 175, 'FIRST_NAME': 'Alyssa', 'LAST_NAME': 'Hutton', 'SALARY': 8800}, {'EMPLOYEE_ID': 176, 'FIRST_NAME': 'Jonathon', 'LAST_NAME': 'Taylor', 'SALARY': 8600}, {'EMPLOYEE_ID': 177, 'FIRST_NAME': 'Jack', 'LAST_NAME': 'Livingston', 'SALARY': 8400}]