Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE MsfDataRecords(
    AccountNumber text,
    ProductCategory text,
    ProductQuantity numeric
);

CREATE TABLE


INSERT INTO MsfDataRecords(AccountNumber, ProductCategory, ProductQuantity) VALUES
    ('A1', 'Food', 3),
    ('A1', 'Food', 1),
    ('A2', 'Food', 3),
    ('A2', 'Electronics', 2),
    ('A2', 'Fashion', 10);

INSERT 0 5


SELECT * FROM MsfDataRecords


accountnumber
productcategory
productquantity


A1
Food
3

A1
Food
1

A2
Food
3

A2
Electronics
2

A2
Fashion
10



SELECT 5


select * from crosstab(
    $$
    select AccountNumber , ProductCategory, sum(ProductQuantity) sm
    from MsfDataRecords mdr
    group by 1,2
    $$
)as ct(
    AccountNumber text,
    Food numeric,
    Electronics numeric,
    Fashion numeric
);


accountnumber
food
electronics
fashion


A2
2
3
null

A1
4
null
null

A2
10
null
null



SELECT 3

accountnumber	food	electronics	fashion
A2	2	3	null
A1	4	null	null
A2	10	null	null