SELECT ID, NAME, CHIEF_ID, SALARY, DEPARTMENT_ID
FROM EMPLOYEE E
WHERE SALARY/2 = (SELECT AVG(SALARY)
FROM EMPLOYEE X
WHERE E.DEPARTMENT_ID = X.DEPARTMENT_ID AND E.CHIEF_ID = E.ID)