[LeetCode] 1965. Employees With Missing Information

😎풀이

1. Employees 테이블 조회
2. employee_id가 Salaries에 존재하지 않는 컬럼만 필터링
3. Salaries 테이블 조회
4. employee_id가 Employees에 존재하지 않는 컬럼만 필터링
5. 두 결과를 병합하여 employee_id 기준 오름차 순 정렬하여 조회회

(SELECT
    employee_id
FROM
    Employees
WHERE
    employee_id NOT IN (
        SELECT employee_id FROM Salaries
    )
UNION ALL
SELECT
    employee_id
FROM
    Salaries
WHERE
    employee_id NOT IN (
        SELECT employee_id FROM Employees
    )) ORDER BY employee_id