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%')