empnam,empno, typ1,total_cfil
a       1     20    1
a       1     20    3 
a       1     20    1
a       1     20    2
a       1     18    10 
a       1     18    32
b
b
c
c
..
..
***********************
i need result from table mucurtw to new table or cursor sum typ1 and count typ1 it all fields is CHR type as..
empnam,empno, typ1,newtotal_cfil,count1
a      1      20      7            4
a      1      18      42           2
.
.