princefarzamThe distribution of Algo between wildlife warrior NFT owners
Updated 2022-06-23
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH Asset_id AS (
select
ASSET_ID,
ASSET_NAME
from algorand.asset
where asset_name like 'Warrior Croc%'
and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU'
or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ'))
SELECT
CASE
WHEN BALANCE >= 1 AND BALANCE < 10 THEN '1_10 Algos'
WHEN BALANCE >= 10 AND BALANCE < 100 THEN '10_ 100 Algos'
WHEN BALANCE >= 100 AND BALANCE < 1000 THEN '100 _ 1,000 Algos'
WHEN BALANCE >= 1000 AND BALANCE < 10000 THEN '1,000 _ 10,000 Algos'
WHEN BALANCE >= 10000 THEN '10,000+ Algos'
ELSE '0 _ 1 Algo'
END AS category,
COUNT(DISTINCT A.ADDRESS) AS Number_of_NFT_owners
FROM flipside_prod_db.algorand.account_asset A INNER JOIN Asset_id B ON A.ASSET_ID=B.ASSET_ID
INNER JOIN flipside_prod_db.algorand.account C ON A.ADDRESS=C.ADDRESS
GROUP BY 1
ORDER BY 2 DESC