Looks good! No results on the third SQL challenge?
SELECT employees.*, departments.dept_name FROM employees
JOIN dept_manager ON dept_manager.emp_no = employees.emp_no
JOIN departments ON departments.dept_no = dept_manager.dept_no
(excluding to_date restriction, but still...)