SQLD 기출문제 예상문제 174번

다음 문제를 풀어보세요.

다음 중 아래 SQL 쿼리의 실행 결과로 가장 적절한 것을 고르시오.

SELECT
    custid,
    SUM(DECODE(orderdate, '2023-01-01', saleprice, 0)) AS "20230101",
    SUM(DECODE(orderdate, '2023-01-02', saleprice, 0)) AS "20230102",
    SUM(DECODE(orderdate, '2023-01-03', saleprice, 0)) AS "20230103"
FROM
    Orders
GROUP BY
    custid;

[Orders 테이블 구조]

CREATE TABLE Orders (
    orderid INTEGER PRIMARY KEY,
    custid INTEGER,
    bookid INTEGER,
    saleprice INTEGER,
    orderdate DATE
);

INSERT INTO Orders (orderid, custid, bookid, saleprice, orderdate) VALUES (1, 1, 1, 10000, '2023-01-01');
INSERT INTO Orders (orderid, custid, bookid, saleprice, orderdate) VALUES (2, 1, 2, 12000, '2023-01-02');
INSERT INTO Orders (orderid, custid, bookid, saleprice, orderdate) VALUES (3, 2, 3, 15000, '2023-01-01');
INSERT INTO Orders (orderid, custid, bookid, saleprice, orderdate) VALUES (4, 2, 4, 16000, '2023-01-03');
INSERT INTO Orders (orderid, custid, bookid, saleprice, orderdate) VALUES (5, 1, 5, 8000, '2023-01-03');