select
  inst_id,                                 -- INST_ID NUMBER
  kmmrdbuc,                                -- BUCKET NUMBER
  sum(kmmrdcnt)                            -- COUNT NUMBER
from
  x$kmmrd
where
  kmmrdpro!=hextoraw('00')
group by
  inst_id,
  kmmrdbuc