case

when amount/pow(10,decimal)>0 and amount/pow(10,decimal)<10 then '0 To 10'

when amount/pow(10,decimal)>=10 and amount/pow(10,decimal)<100 then '10 To 100'

when amount/pow(10,decimal)>=100 and amount/pow(10,decimal)<500 then '100 To 500'

when amount/pow(10,decimal)>=500 and amount/pow(10,decimal)<1000 then '500 To 1000'

when amount/pow(10,decimal)>=1000 and amount/pow(10,decimal)<5000 then '1000 To 5000'

when amount/pow(10,decimal)>=5000 and amount/pow(10,decimal)<10000 then '5000 To 10000'

when amount/pow(10,decimal)>=10000 and amount/pow(10,decimal)<20000 then '10000 To 20000'

when amount/pow(10,decimal)>=20000 then 'Greater than 10,000'

end as Distribution

,count(DISTINCT tx_id) as tx_count

,count(DISTINCT sender) as wallets

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

,avg(amount/pow(10,decimal)) as avg_volume

from axelar.core.fact_transfers

where block_timestamp::date>=CURRENT_DATE-{{Days}}

and CURRENCY='uusdc'

and TX_SUCCEEDED=true

and Distribution is not null

group by 1