distinct sender,

sum(amount/pow(10,decimal)) as volume

from osmosis.core.fact_transfers

where transfer_type in ('IBC_TRANSFER_IN')

and TX_SUCCEEDED = 'TRUE'

and currency='ibc/AB589511ED0DD5FA56171A39978AFBF1371DB986EC1C3526CE138A16377E39BB'

group by 1 having volume is not null

),

tb2 as (select *,

regexp_substr (sender,'[a-zA-Z]+|\d+') as source_chain,

regexp_substr (receiver,'[a-zA-Z]+|\d+') as Destination_chain,

CONCAT(source_chain,' -> ',Destination_chain) as Path_transfer

from axelar.core.fact_transfers

where TX_SUCCEEDED = 'TRUE'

and RECEIVER in (select sender from tb1)

select

source_chain,

count (distinct tx_id) as no_trabsfer

from tb2

where BLOCK_TIMESTAMP>='2022-11-01'

group by 1