SQL Server 2017

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

CREATE TABLE trans (
  user_id varchar(10),
  purchase_date DATE,
  prod_ab_amt INT,
  prod_bf_amt FLOAT,
  prod_gm_amt INT,
  catg_cg_amt INT,
  catg_dh_amt INT,
  catg_xy_amt FLOAT,
  catg_mk_amt INT,
  brand_hk_amt INT,
  brand_hp_amt FLOAT,
  brand_vm_amt INT
);

INSERT INTO trans (user_id, purchase_date, prod_ab_amt, prod_bf_amt, prod_gm_amt,
  catg_cg_amt, catg_dh_amt, catg_xy_amt,catg_mk_amt,brand_hk_amt, brand_hp_amt,brand_vm_amt)
VALUES ('A','2008-01-11' ,10,6,10,10,11,20,5,9,7,3)
        ,('A','2008-02-11' ,10,6,20,10,11,10,6,4,5,2)
        ,('A','2008-02-11' ,1,1,1,2,1,2,1,1,1,2)
        ,('B','2008-02-11' ,10,6,40,20,11,10,3,4,7,8)
        ,('B','2008-03-11' ,10,6,40,20,11,10,2,5,6,9)
        ,('C','2008-02-11' ,10,6,40,10,11,10,2,5,9,1)
        ,('C','2008-02-11' ,1,2,2,3,1,2,2,1,1,1)
       , ('B','2008-04-11' ,5,18,10,5,11,7,1,3,4,7)
       ,('A','2008-11-11' ,6,18,2,5,10,10,2,5,8,3)
       ,('A','2008-12-11' ,10,28,1,7,11,7,2,7,9,10)
       ,('B','2008-12-11' ,10,28,1,7,11,7,3,5,9,6)
      ,('B','2008-12-11' ,1,2,1,1,2,2,3,1,2,1)
       ,('C','2008-12-16' ,10,28,1,7,11,7,1,4,5,7)
    ,('A','2009-01-01' ,10,2,1,7,9,7,2,4,3,9)
       ,('A','2009-03-11' ,10,28,1,7,11,7,2,4,3,9)
       ,('B','2009-01-11' ,100,18,1,5,11,7,1,8,9,6)
     ,('B','2009-01-11' ,1,2,1,5,3,7,1,8,9,6)
       ,('C','2009-01-11' ,25,18,1,5,11,7,4,5,7,3)
       ,('C','2009-02-11' ,35,18,1,5,11,7,2,10,5,9)
       ,('B','2009-03-11' ,9,18,1,5,11,7,4,3,6,14)
       ,('A','2009-07-11' ,10,18,1,40,10,10,4,12,3,6)
       ,('A','2009-10-11' ,10,18,1,5,11,7,3,6,7,12)
       ,('A','2009-10-11' ,1,2,1,5,3,7,3,6,7,2)
       ,('B','2009-11-11' ,10,18,11,15,11,17,1,10,9,8)
       ,('C','2009-12-11' ,10,18,1,5,11,7,2,5,6,9)
       ,('C','2009-12-11' ,1,1,1,5,2,7,2,5,6,9);

CREATE TABLE amt_sum (
  user_id varchar(10),
  purch_yr DATE,
  purch_half_period INT,
  prod_ab_amt INT,
  prod_bf_amt INT,
  prod_gm_amt INT,
  catg_cg_amt INT,
  catg_dh_amt INT,
  catg_xy_amt INT,
  catg_mk_amt INT,
  brand_hk_amt INT,
  brand_hp_amt INT,
  brand_vm_amt INT
);

INSERT INTO amt_sum(user_id, purch_yr, purch_half_period, 
  prod_ab_amt,prod_bf_amt,prod_gm_amt,catg_cg_amt,
  catg_dh_amt,catg_xy_amt,catg_mk_amt,brand_hk_amt,
  brand_hp_amt,brand_vm_amt
  )

VALUES 
  ('A', '2008', 1,21,13,31,22,23,32,12,14,13,7),
  ('A', '2008', 2,16,46,3,12,21,17,4,12,17,13),
  ('A', '2009', 1,20,30,2,14,20,14,4,8,6,18),
  ('A', '2009', 2,21,38,3,50,24,24,10,24,17,20),
  ('B', '2008', 1,25,30,90,45,33,27,7,12,17,20),
  ('B', '2008', 2,21,30,2,8,13,9,6,6,11,7),
  ('B', '2009', 1,110,38,3,15,25,21,6,19,24,26),
  ('B', '2009', 2,10,18,11,15,11,17,1,10,9,8),
  ('C', '2008', 1,11,8,42,13,12,12,4,6,10,2),
  ('C', '2008', 2,10,28,1,7,11,7,1,4,5,7),
  ('C', '2009', 1,60,36,2,10,22,14,6,15,12,12),
  ('C', '2009', 2,11,19,2,10,13,14,4,10,12,18);

select *
from amt_sum

user_id	purch_yr	purch_half_period	prod_ab_amt	prod_bf_amt	prod_gm_amt	catg_cg_amt	catg_dh_amt	catg_xy_amt	catg_mk_amt	brand_hk_amt	brand_hp_amt	brand_vm_amt
A	2008-01-01	1	21	13	31	22	23	32	12	14	13	7
A	2008-01-01	2	16	46	3	12	21	17	4	12	17	13
A	2009-01-01	1	20	30	2	14	20	14	4	8	6	18
A	2009-01-01	2	21	38	3	50	24	24	10	24	17	20
B	2008-01-01	1	25	30	90	45	33	27	7	12	17	20
B	2008-01-01	2	21	30	2	8	13	9	6	6	11	7
B	2009-01-01	1	110	38	3	15	25	21	6	19	24	26
B	2009-01-01	2	10	18	11	15	11	17	1	10	9	8
C	2008-01-01	1	11	8	42	13	12	12	4	6	10	2
C	2008-01-01	2	10	28	1	7	11	7	1	4	5	7
C	2009-01-01	1	60	36	2	10	22	14	6	15	12	12
C	2009-01-01	2	11	19	2	10	13	14	4	10	12	18