select
INST_ID, -- INST_ID NUMBER
KWQSIQID, -- QID NUMBER
KWQSINWT, -- WAITING NUMBER
KWQSINRD, -- READY NUMBER
KWQSINEX, -- EXPIRED NUMBER
KWQSIAVGMSGAGE, -- AVERAGE_MSG_AGE NUMBER
KWQSINCO, -- TOTAL_CONSUMERS NUMBER
KWQSITWT, -- TOTAL_WAIT NUMBER
DECODE( -- AVERAGE_WAIT NUMBER
KWQSINCO, 0, 0, KWQSITWT/KWQSINCO)
from
X$KWQSI