sum(gas_used/10E12) as Gas

from near.core.fact_transactions

where --TX_RECEIVER like '%app%'

BLOCK_TIMESTAMP::date like '2022-06%' -- past month

and substr(tx:"outcome":"outcome":"status",3,7) = 'Success'

group by TX_RECEIVER

order by Gas desc