case

when SUPPLIED_USD>0 and SUPPLIED_USD<=100 then 'a. < 100 USD'

when SUPPLIED_USD>100 and SUPPLIED_USD<=1000 then 'b. 100-1,000 USD'

when SUPPLIED_USD>1000 and SUPPLIED_USD<=5000 then 'c. 1,000-5,000 USD'

when SUPPLIED_USD>5000 and SUPPLIED_USD<=10000 then 'd. 5,000-10,000 USD'

when SUPPLIED_USD>10000 and SUPPLIED_USD<=20000 then 'e. 10,000-20,000 USD'

when SUPPLIED_USD>20000 then 'e. > 20,000 USD'

end as bucket,

count(distinct tx_hash) as sale_no,

count(distinct DEPOSITOR_ADDRESS) as wallets

from ethereum.aave.ez_deposits

where BLOCK_TIMESTAMP>=CURRENT_DATE- {{Time_period_days}}

group by 1 having bucket is not null