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