PapasotTiger Chi Holders
Updated 2023-01-03
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
select
count(DISTINCT(address)) tiger_holders,
CASE
when asset_name like '%Tiger Chi #%' then 'TigerChi holder'
when asset_name like '%TigerChi Special #%' then 'Special holder'
end as generation
from algorand.account_asset
where amount = '1'
and (ASSET_NAME like '%TigerChi Special #%'
or asset_name like '%Tiger Chi #%')
group by generation
Run a query to Download Data