SQLD 기출문제 예상문제 375번

다음 문제를 풀어보세요.

다음 중 아래 SQL의 실행결과를 고르시오.

[테이블 구조]

CREATE TABLE PRODUCTS (
    PRODUCT_ID   INTEGER PRIMARY KEY,
    PRODUCT_NAME VARCHAR(100),
    CATEGORY     VARCHAR(50),
    PRICE        DECIMAL(10, 2)
);

CREATE TABLE ORDERS (
    ORDER_ID    INTEGER PRIMARY KEY,
    CUSTOMER_ID VARCHAR(50),
    PRODUCT_ID  INTEGER,
    QUANTITY    INTEGER,
    ORDER_DATE  DATE,
    FOREIGN KEY (PRODUCT_ID) REFERENCES PRODUCTS(PRODUCT_ID)
);

[테이블 데이터]

-- PRODUCTS 테이블

PRODUCT_ID PRODUCT_NAME CATEGORY PRICE
101 Laptop A Electronics 1200
102 Mouse B Electronics 50
103 Keyboard C Electronics 80
201 Shirt D Apparel 30
202 Pants E Apparel 60
301 Book F Books 25
302 Magazine G Books 10

-- ORDERS 테이블

ORDER_ID CUSTOMER_ID PRODUCT_ID QUANTITY ORDER_DATE
1 C001 101 2 2023-01-01
2 C002 102 5 2023-01-02
3 C001 201 10 2023-01-03
4 C003 101 1 2023-01-04
5 C002 301 20 2023-01-05
6 C004 202 5 2023-01-06
7 C001 103 3 2023-01-07
8 C005 101 5 2023-01-08

[SQL 쿼리]

SELECT
    P.CATEGORY,
    SUM(O.QUANTITY * P.PRICE) AS TOTAL_SALES
FROM
    ORDERS O
JOIN
    PRODUCTS P ON O.PRODUCT_ID = P.PRODUCT_ID
GROUP BY
    P.CATEGORY
HAVING
    SUM(O.QUANTITY * P.PRICE) > 500;