msg_value:execute_msg:initiate_transfer:recipient_chain::string as chain, case

when chain = 1 then 'solana'

when chain = 2 then 'ethereum'

when chain = 4 then 'BSC'

when chain = 5 then 'polygon'

when chain = 6 then 'avalanche'

when chain = 7 then 'oasis'

else null end as chains,

count(distinct tx_id) as tx_counts,

count(distinct msg_value:sender::string) as users

from terra.msgs

where msg_value:contract::string = 'terra10nmmwe8r3g99a9newtqa7a75xfgs2e8z87r2sf'

and msg_value:execute_msg:initiate_transfer:asset:info:token:contract_addr::string is not null and tx_status = 'SUCCEEDED'

group by 1

order by 4 desc