SQLD 기출문제 예상문제 239번

다음 문제를 풀어보세요.

다음 중 아래 SQL에 대한 설명으로 가장 적절한 것을 고르시오.

[테이블 구조]

CREATE TABLE EMPLOYEES (
    EMP_ID      INT PRIMARY KEY,
    EMP_NAME    VARCHAR(100),
    DEPT_ID     INT,
    SALARY      DECIMAL(10, 2),
    HIRE_DATE   DATE
);

INSERT INTO EMPLOYEES (EMP_ID, EMP_NAME, DEPT_ID, SALARY, HIRE_DATE) VALUES
(101, '김철수', 10, 5000, '2020-01-15'),
(102, '이영희', 20, 6000, '2019-03-20'),
(103, '박민수', 10, 5000, '2021-07-01'),
(104, '최지영', 30, 4500, '2022-02-10'),
(105, '정대현', 20, 6000, '2018-11-05'),
(106, '한수진', 10, 4800, '2023-04-22'),
(107, '강동원', 30, 4500, '2021-09-01'),
(108, '신미나', 20, 5500, '2020-06-18');

[SQL 쿼리]

SELECT
    EMP_ID,
    EMP_NAME,
    DEPT_ID,
    SALARY,
    ROW_NUMBER() OVER (PARTITION BY DEPT_ID ORDER BY SALARY DESC, EMP_ID ASC) AS RNK
FROM
    EMPLOYEES;