select
    e.last_name,
    e.first_name,
    d.dept_name
from
    employees e
    left join dept_emp c on e.emp_no = c.emp_no
    left join departments d on c.dept_no = d.dept_no