case

when sender ilike 'stars%' then 'STARS'

when sender ilike 'axelar%' then 'AXL'

when sender ilike 'evmos%' then 'EVMOS'

when sender ilike 'juno%' then 'JUNO'

when sender ilike 'stride%' then 'stride'

when sender ilike 'terra%' then 'Terra'

when sender ilike 'cosmos%' then 'ATOM'

else 'Other' end as chain,

count(distinct tx_id) as txn_count,

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

from osmosis.core.fact_transfers

where 1 = 1

and sender not ilike 'osmo%'

and receiver ilike 'osmo%'

group by chain