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%')
more than average salary refers to salary > AVG(salary); employees who work in a department with employees who have the letter J in their first name refers to department_id IN (SELECT department_id FROM employees WHERE first_name LIKE '%J%'); ids, full names, and salaries refer to employee_id, first_name, last_name, and salary respectively;