shahdadi-9ptm8Ydistribution of algo
Updated 2022-06-19
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
with id as(select asset_id
from algorand.asset
where asset_name like 'Warrior Croc%'
and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
),a as(
select distinct address
from flipside_prod_db.algorand.account_asset where asset_id in (select asset_id from id) and ASSET_CLOSED='FALSE'
),b as(
select address,balance
from flipside_prod_db.algorand.account where address in (select address from a)
)
select count(address),case when balance<= 100 then 'under 100'
when balance > 100 and balance <= 1000 then '100-1000'
when balance > 1000 and balance <= 10000 then '1000-10000'
when balance > 10000 then 'over 10000' end as amount
from b
group by amount
Run a query to Download Data