PapasotTiger Chi Holders
    Updated 2023-01-03
    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