题解 | 获取所有非manager员工当前的薪水情况

WITH T1 AS (
    SELECT
        *
    FROM
        employees e JOIN dept_emp de USING(emp_no)
    WHERE 
        e.emp_no NOT IN (
            SELECT
                emp_no
            FROM 
                dept_manager
        )
)
SELECT
    dept_no,
    T1.emp_no,
    salary
FROM
    T1 JOIN salaries s USING(emp_no)