select date_trunc('month',BLOCK_TIMESTAMP)as month

,case

when SENDER ilike 'cosmos%' then 'COSMOS'

when SENDER ilike 'evmos%' then 'EVMOS'

when SENDER ilike 'juno%' then 'JUNO'

when SENDER ilike 'chihuahua%' then 'CHIHUAHUA'

when SENDER ilike 'stars%' then 'STARS'

when SENDER ilike 'umee%' then 'UMEE'

when SENDER ilike 'secret%' then 'SECRET'

when SENDER ilike 'cro%' then 'CRO'

when SENDER ilike 'terra%' then 'TERRA'

when SENDER ilike 'axelar%' then 'AXELAR'

else 'OTHER CHAINS' end as chains

,count(distinct TX_ID) as transfer_count

,count(distinct SENDER)as sender_count

from osmosis.core.fact_transfers

where RECEIVER ilike 'osmo%'

and SENDER not ilike 'osmo%'

and TX_SUCCEEDED='TRUE'

group by 1,2)

select chains

,max(transfer_count) as max

,min(transfer_count) as min

,median(transfer_count) as med

,avg(transfer_count) as avg

from tab1

group by 1