distinct b.MSG_TYPE,

sum(GAS_USED/1e9) as collected_fee

from osmosis.core.fact_transactions s left outer join osmosis.core.fact_msgs b on s.tx_id=b.tx_id

where s.BLOCK_TIMESTAMP>= CURRENT_DATE-30

and s.TX_STATUS='SUCCEEDED'

group by 1

order by 2 DESC