SELECT JC.A,
             ROWNUM SNO, --serial number
             JC.B,
             SUM(CHR.AMOUNT),
             SUM(CHR.FINALAMOUNT),
             JC.C,
             JC.D,
             JC.E,
             JC.F,
             JC.G
        FROM CHARGES CHR
       WHERE JC.B = '12111'
         AND JC.STATUS = 'INVOICED'
       GROUP BY JC.A, JC.B, JC.C, JC.D, JC.E, JC.F, JC.G;

SQL> select deptno, job, count(*) nb, 
  2         row_number() over (order by deptno, job) overall_num,
  3         row_number() over (partition by deptno order by job) indept_num
  4  from emp
  5  group by deptno, job
  6  order by deptno, job
  7  /
    DEPTNO JOB               NB OVERALL_NUM INDEPT_NUM
---------- --------- ---------- ----------- ----------
        10 PRESIDENT          1           1          1
        20 ANALYST            2           2          1
        20 CLERK              2           3          2
        20 MANAGER            1           4          3
        30 CLERK              1           5          1
        30 MANAGER            1           6          2
        30 SALESMAN           4           7          3

7 rows selected.