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