CREATE CURSOR table1 (codes c(7),names c(10),amount n(4)) INSERT INTO table1 VALUES ('1','',0) INSERT INTO table1 VALUES ('11','',0) INSERT INTO table1 VALUES ('1101','',0) INSERT INTO table1 VALUES ('1101001','',200) INSERT INTO table1 VALUES ('1101002','',600) INSERT INTO table1 VALUES ('1101005','',700) INSERT INTO table1 VALUES ('1102','',0) INSERT INTO table1 VALUES ('1102001','',100) INSERT INTO table1 VALUES ('1102003','',400) INSERT INTO table1 VALUES ('12','',0) INSERT INTO table1 VALUES ('1201','',0) INSERT INTO table1 VALUES ('1201001','',800) INSERT INTO table1 VALUES ('1201003','',300)I need result shown in image