select

iff(TX_SUCCEEDED='TRUE','SUCCESS','FAIL') as tx_status,

'Flow' as category,

count(distinct tx_id) as tx

from flow.core.fact_transactions

group by 1,2

select

iff(tx_receipt[0]:outcome:status:Failure is null,'SUCCESS','FAIL') as tx_status,

'Near' as category,

count(distinct txn_hash) as tx

from flipside_prod_db.mdao_near.transactions

group by 1,2

select

iff(status='SUCCESS','SUCCESS','FAIL') as tx_status,

'Ethereum' as category,

count(distinct tx_hash) as tx

from ethereum.core.fact_transactions

group by 1,2