题解 | #查找所有已经分配部门的员工的信息

select
    a.last_name as last_name,
    a.first_name as first_name,
    b.dept_no as dept_no
from
    (
        select
            *
        from
            employees
    ) a
    join (
        select
            *
        from
            dept_emp
    ) b
on a.emp_no=b.emp_no