Show the employee_id, his join_date, his manager_id, his manager_name, his manager_salary

SELECT e.EMPLOYEE_ID,e.HIRE_DATE,e.MANAGER_ID,mng.FIRST_NAME,mng.SALARY

FROM employees AS e 

    JOIN

    employees AS mng 

    ON e.MANAGER_ID = mng.EMPLOYEE_ID