get the details of employees who manage a department.
select distinct * from employees as t1 join departments as t2 on t1.department_id = t2.department_id where t1.employee_id = t2.manager_id