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%'