Untitled

SELECT employee_id, first name, last name, salary FROM employees e WHERE salary > (SELECT AVG(salary) FROM employees WHERE department_id= e.department_id GROUP BY department_id );