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.
CREATE TABLE employees (
    employee_id VARCHAR,
    first_name VARCHAR,
    last_name VARCHAR,
    salary INTEGER,
    department_id VARCHAR
)
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%')
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: 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. ### Input: CREATE TABLE employees (
    employee_id VARCHAR,
    first_name VARCHAR,
    last_name VARCHAR,
    salary INTEGER,
    department_id VARCHAR
) ### Response: 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%')