PapasotOctorand gen 1 + 2 wallets
    Updated 2023-01-03
    select
    count(DISTINCT(address)) octo_holders,
    CASE
    when asset_name like '%Octo Prime Gen2%' then 'Gen2 holder'
    when asset_name like '%Octorand #%' then 'Gen1 holder'
    end as generation
    from algorand.account_asset
    where amount = '1'
    and (ASSET_NAME like '%Octo Prime Gen2%'
    or asset_name like '%Octorand #%')
    group by generation

    Run a query to Download Data