SQLD 기출문제 예상문제 65번

다음 문제를 풀어보세요.

다음 중 아래 테이블 구조와 SQL 쿼리를 기반으로 예상되는 결과에 대한 설명으로 가장 적절한 것을 고르시오.

[테이블 구조]

CREATE TABLE ORDERS (
    ORDER_ID INT PRIMARY KEY,
    CUSTOMER_ID INT,
    ORDER_DATE DATE,
    PRODUCT_ID INT,
    QUANTITY INT,
    PRICE DECIMAL(10, 2)
);

INSERT INTO ORDERS (ORDER_ID, CUSTOMER_ID, ORDER_DATE, PRODUCT_ID, QUANTITY, PRICE) VALUES
(1, 101, '2023-01-01', 1, 2, 100.00),
(2, 102, '2023-01-02', 2, 1, 50.00),
(3, 101, '2023-01-03', 1, 3, 100.00),
(4, 103, '2023-01-04', 3, 1, 200.00),
(5, 102, '2023-01-05', 2, 2, 50.00),
(6, 101, '2023-01-06', 1, 1, NULL),
(7, 104, '2023-01-07', 4, 1, 300.00),
(8, 103, '2023-01-08', 3, 2, NULL);

[SQL 쿼리]

SELECT
    CUSTOMER_ID,
    SUM(PRICE * QUANTITY) AS TOTAL_SPENT
FROM
    ORDERS
WHERE PRICE IS NOT NULL
GROUP BY
    CUSTOMER_ID
HAVING SUM(PRICE * QUANTITY) > 200;