tx_id,

attribute_value as Destination_Chain

from axelar.core.fact_msg_attributes

where tx_succeeded = 'TRUE'

and attribute_key = 'destinationChain'

)

select Token_Currency,

case when token_currency = 'uaxl' then 'AXL'

when token_currency = 'uusdc' then 'USDC'

when token_currency = 'weth-wei' then 'WETH'

when token_currency = 'dot-planck' then 'DOT'

when token_currency = 'wbtc-satoshi' then 'WBTC'

when token_currency = 'dai-wei' then 'DAI'

when token_currency = 'uusdt' then 'USDT'

when token_currency = 'uatom' then 'ATOM'

when token_currency = 'aevmos' then 'EVMOS'

when token_currency = 'uumee' then 'UMEE'

when token_currency = 'uusd' then 'UST'

when token_currency = 'uluna' then 'LUNA'

when token_currency = 'ujuno' then 'JUNO'

when token_currency = 'ncheq' then 'CHEQ'

when token_currency = 'basecro' then 'CRO'

when token_currency = 'uscrt' then 'SCRT'

when token_currency = 'ibc/27394FB092D2ECCD56123C74F36E4C1F926001CEADA9CA97EA622B25F41E5EB2' then 'ATOM'

when token_currency ilike '%ibc/FAFCFDEBFDDFCDDDCFBDEF%' then 'UST'

when token_currency ilike '%ibc/ADEEEBBCCEDDACFFFCBCEBFCB%' then 'LUNA'

when token_currency ilike '%ibc/ABAEFAFFDCBDCDDBAFBAEE%' then 'ATOM'

else token_currency end as Asset_Name,

count (distinct tx_id) as TX_Count,

count (distinct destination_user) as Destination_Users_Count

from (

select *,

case when right (NumbersReplaced,1)='_' then left (NumbersReplaced,LEN(NumbersReplaced)-1) else NumbersReplaced end as Token_Currency

from (