barbodthe distribution of Defly among in wallets
    Updated 2022-02-20
    select case when amount/1e6 between 1 and 1000 then '1-1000'
    WHEN amount/1e6 between 1001 and 10000 then '1k-10k'
    WHEN amount/1e6 between 10001 and 50000 then '10k-50k'
    WHEN amount/1e6 between 50001 and 100000 then '50k-100k'
    WHEN amount/1e6 between 100001 and 200000 then '100k-200k'
    WHEN amount/1e6 between 200001 and 500000 then '200K-500K'
    WHEN amount/1e6 between 500001 and 1000000 then '500K-1M'
    WHEN amount/1e6 between 1000001 and 10000000 then '1M-10M'
    WHEN amount/1e6 between 10000001 and 20000000 then '10M-20M'
    WHEN amount/1e6 between 20000001 and 50000000 then '20M-50M'
    WHEN amount/1e6 between 50000001 and 100000000 then '50M-100M'
    WHEN amount/1e6 between 100000001 and 500000000 then '100M-500M'
    WHEN amount/1e6 > 500000000 then 'greater than 50M'
    end as dely_amount,
    count(address) as number_of_hodlers
    from algorand.account_asset
    where asset_id = 470842789
    and asset_closed = FALSE
    group by 1 having dely_amount is not NULL order by 1 desc
    Run a query to Download Data