--CREATING A NEW TABLE----

CREATE TABLE PIVOT_TRAINING (
  id            NUMBER,
  customer_id   NUMBER,
  product_code  VARCHAR2(5),
  quantity      NUMBER
);

---INSERTING DATA INTO THE TABLE---

INSERT INTO PIVOT_TRAINING VALUES (1, 101, 'DA', 10);
INSERT INTO PIVOT_TRAINING VALUES (2, 101, 'DB', 20);
INSERT INTO PIVOT_TRAINING VALUES (3, 101, 'DC', 30);
INSERT INTO PIVOT_TRAINING VALUES (4, 102, 'DA', 40);
INSERT INTO PIVOT_TRAINING VALUES (5, 102, 'DC', 50);
INSERT INTO PIVOT_TRAINING VALUES (6, 103, 'DA', 60);
INSERT INTO PIVOT_TRAINING VALUES (7, 103, 'DB', 70);
INSERT INTO PIVOT_TRAINING VALUES (8, 103, 'DC', 80);
INSERT INTO PIVOT_TRAINING VALUES (9, 103, 'DD', 90);
INSERT INTO PIVOT_TRAINING VALUES (10, 104, 'DA', 100);
COMMIT;

---CHECKING THE DATA---

SELECT * FROM PIVOT_TRAINING;

---Pivot data in SQL---


SELECT * FROM
(select CUSTOMER_ID,PRODUCT_CODE,QUANTITY from PIVOT_TRAINING)
PIVOT ( SUM(QUANTITY) AS SUM_QUANTITY FOR  (PRODUCT_CODE) IN ( 'DA' DA,'DB' DB,'DC' DC,'DD' DD));