Updated 2023-06-06
    select
    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 DEPOSITOR_ADDRESS) as users

    from ethereum.aave.ez_deposits
    where symbol = 'AAVE'
    group by 1 having bucket is not null


    Run a query to Download Data