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