SELECT
  A.inst_id,                               -- INST_ID NUMBER
  CONSUMER_GROUP_ID_KSFDSTCG,              -- CONSUMER_GROUP_ID NUMBER
  sum(                                     -- SMALL_READ_MEGABYTES NUMBER
    round((SBRDATA_KSFDSTCG + A_SBRDATA_KSFDSTCG) / 2048)),
  sum(                                     -- SMALL_WRITE_MEGABYTES NUMBER
    round((SBWDATA_KSFDSTCG + A_SBWDATA_KSFDSTCG) / 2048)),
  sum(                                     -- LARGE_READ_MEGABYTES NUMBER
    round((MBRDATA_KSFDSTCG + A_MBRDATA_KSFDSTCG) / 2048)),
  sum(                                     -- LARGE_WRITE_MEGABYTES NUMBER
    round((MBWDATA_KSFDSTCG + A_MBWDATA_KSFDSTCG) / 2048)),
  sum(                                     -- SMALL_READ_REQS NUMBER
    SBRREQS_KSFDSTCG + A_SBRREQS_KSFDSTCG),
  sum(                                     -- SMALL_WRITE_REQS NUMBER
    SBWREQS_KSFDSTCG + A_SBWREQS_KSFDSTCG),
  sum(                                     -- LARGE_READ_REQS NUMBER
    MBRREQS_KSFDSTCG + A_MBRREQS_KSFDSTCG),
  sum(                                     -- LARGE_WRITE_REQS NUMBER
    MBWREQS_KSFDSTCG + A_MBWREQS_KSFDSTCG),
  sum(                                     -- NUMBER_OF_WAITS NUMBER
    WREQS_KSFDSTCG + A_WREQS_KSFDSTCG),
  sum(                                     -- WAIT_TIME NUMBER
    WTIME_KSFDSTCG + A_WTIME_KSFDSTCG) 
FROM
  X$KSFDSTCG A,
  x$kgskcft B
WHERE
  B.class_id_kgskcft = A.consumer_group_id_ksfdstcg
GROUP BY
  A.INST_ID,
  CONSUMER_GROUP_ID_KSFDSTCG