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