*mytable empno file no val1 val2 1 2 6 500 80 1 2 28 100 50 1 3 10 200 70 2 2 8 100 40 2 4 18 150 60
empno count1 file no val1 val2 sum1(val1+val2) 1 3 7 44 800 200 1000 2 2 6 26 250 100 350