select

case

when FROM_AMOUNT_USD>0 and FROM_AMOUNT_USD<10 then 'Below $10'

when FROM_AMOUNT_USD>=10 and FROM_AMOUNT_USD<=100 then '$10~$100'

when FROM_AMOUNT_USD>100 and FROM_AMOUNT_USD<=1000 then '$100~$1K'

when FROM_AMOUNT_USD>1000 and FROM_AMOUNT_USD<=10000 then '$1K~$10K'

when FROM_AMOUNT_USD>10000 then '$Up to $10K' end as dis_volume

,count(distinct FROM_ADDRESS) as swappers

,count(distinct TX_ID) as swaps

from thorchain.defi.fact_swaps

where AFFILIATE_ADDRESS='lifi'

group by 1