PapasotOctorand gen1&2 wallets
    Updated 2023-01-03
    with octorand2 as (
    SELECT
    address,
    asset_id,
    asset_name
    from algorand.account_asset
    where ASSET_NAME like '%Octo Prime Gen2%' AND
    amount = 1
    )

    select
    count(DISTINCT(a.address)) holders

    from algorand.account_asset a
    left join octorand2 b on b.address = a.address
    where amount = '1'
    and a.ASSET_NAME like '%Octorand #%'
    and b.asset_name like '%Octo Prime Gen2%'

    Run a query to Download Data