SQLD 기출문제 예상문제 379번

다음 문제를 풀어보세요.

다음 중 아래 SQL 쿼리의 실행 결과로 예상되는 PRODUCTS 테이블의 정렬 순서에 대한 설명으로 가장 적절한 것을 고르시오.

[테이블 구조]

CREATE TABLE PRODUCTS (
    PRODUCT_ID INT PRIMARY KEY,
    PRODUCT_NAME VARCHAR(100),
    CATEGORY VARCHAR(50),
    PRICE DECIMAL(10, 2),
    STOCK_QUANTITY INT,
    LAST_UPDATED_DATE DATE
);

[테이블 데이터]

INSERT INTO PRODUCTS (PRODUCT_ID, PRODUCT_NAME, CATEGORY, PRICE, STOCK_QUANTITY, LAST_UPDATED_DATE) VALUES
(101, 'Laptop Pro', 'Electronics', 1200.00, 50, '2023-10-01'),
(102, 'Gaming Mouse', 'Electronics', 75.00, 150, '2023-09-15'),
(103, 'Mechanical Keyboard', 'Electronics', 120.00, 150, '2023-10-20'),
(104, 'Monitor 4K', 'Electronics', 450.00, 30, '2023-09-25'),
(105, 'USB Hub', 'Accessories', 25.00, 200, NULL),
(106, 'External SSD', 'Electronics', 150.00, 50, '2023-10-05'),
(107, 'Ergonomic Chair', 'Furniture', 300.00, NULL, '2023-08-01'),
(108, 'Desk Lamp', 'Furniture', 50.00, 100, '2023-10-10');

[SQL 쿼리]

SELECT
    PRODUCT_ID,
    PRODUCT_NAME,
    STOCK_QUANTITY,
    PRICE,
    LAST_UPDATED_DATE
FROM
    PRODUCTS
ORDER BY
    STOCK_QUANTITY DESC NULLS LAST,
    PRICE ASC,
    LAST_UPDATED_DATE DESC NULLS FIRST;