SQLP CBT 기출문제 예상문제 39번

다음 문제를 풀어보세요.

다음 중 아래 테이블 구조와 SQL 쿼리에 대한 설명으로 가장 적절하지 않은 것을 고르시오.

CREATE TABLE orders (
    order_id INT PRIMARY KEY,
    customer_id INT,
    order_date DATE,
    product_id INT,
    quantity INT,
    price DECIMAL(10, 2)
);

CREATE INDEX idx_customer_order_date ON orders (customer_id, order_date DESC);

SELECT
    customer_id,
    SUM(price * quantity) AS total_spent
FROM
    orders
WHERE
    customer_id IN (1, 2, 3)
    AND order_date BETWEEN '2023-01-01' AND '2023-03-31'
GROUP BY
    customer_id
ORDER BY
    total_spent DESC;