SELECT result.name FROM
    (SELECT table_1.NAME as name, table_1.SALARY as chief_salary, AVG(table_2.SALARY) as employees_avg_salary
        FROM EMPLOYEE as table_1
        LEFT JOIN EMPLOYEE as table_2
            ON table_1.ID = table_2.CHIEF_ID
        GROUP BY table_1.ID, table_1.NAME, table_1.SALARY) as result
    WHERE result.chief_salary >= 2 * result.employees_avg_salary