Task: Text to Code
Input (English): 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?
Output (English): 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%')