when sender like 'osmo%' then 'OSMO'

when sender like 'kujira%' then 'KUJIRA'

when sender like 'terra%' then 'TERRA'

when sender like 'evmos%' then 'EVMOS'

when sender like 'umee%' then 'UMEE'

when sender like 'cre%' then 'CRE'

when sender like 'comdex%' then 'COMDEX'

when sender like 'juno%' then 'JUNO'

when sender like 'secret%' then 'SECRET'

when sender like 'cosmos%' then 'COSMOS'

else sender end as chain

from axelar.core.fact_transfers

where currency like '%wbnb%' and receiver like 'axelar%' and sender not like 'axelar%' and block_timestamp::date > '2022-11-01'

group by chain