when receiver like 'osmo%' then 'OSMO'

when receiver like 'kujira%' then 'KUJIRA'

when receiver like 'terra%' then 'TERRA'

when receiver like 'evmos%' then 'EVMOS'

when receiver like 'umee%' then 'UMEE'

when receiver like 'cre%' then 'CRE'

when receiver like 'comdex%' then 'COMDEX'

when receiver like 'juno%' then 'JUNO'

when receiver like 'secret%' then 'SECRET'

when receiver like 'cosmos%' then 'COSMOS'

else receiver end as chain

from axelar.core.fact_transfers

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

and receiver!='acre1y4pfpkwpy6myskp7pne256k6smh2rjtaaf0xv9' and receiver!='0x63b1B57c9996bD996e1c0555bc85D6a05eCC8512'

group by chain