select *,

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

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

Sender_Chain|| ' To ' || Receiver_Chain as Transfer_Path,

lower (split(currency,'-')[0]) as Symbol1,

iff (Symbol1 ilike 'u%',substring(Symbol1,2,LEN(Symbol1)), Symbol1) as Symbol

from axelar.core.fact_transfers

where transfer_type in ('IBC_TRANSFER_IN','IBC_TRANSFER_OUT')

and currency = 'uusdc'

and TX_SUCCEEDED = 'TRUE')

select transfer_Type,

case when ((amount/POW (10,decimal))) < 10 then 'Less Than $10'

when ((amount/POW (10,decimal))) >= 10 and ((amount/POW (10,decimal))) < 100 then '$10 - $100'

when ((amount/POW (10,decimal))) >= 100 and ((amount/POW (10,decimal))) < 1000 then '$100 - $1000'

when ((amount/POW (10,decimal))) >= 1000 and ((amount/POW (10,decimal))) < 10000 then '$1000 - $10000'

else 'More Than $10000' end as amountt,

count (distinct tx_id) as Transfers_Count

from maintable

group by 1,2