Use a self join to find the manager of the employee.

• Join the employee table with itself on the manager_id and employee_id columns

• Select the manager's details based on the employee's manager_id