select last_name,
    first_name,
    dept_name
from employees
left join dept_emp using(emp_no)
left join departments using(dept_no)