nfts as (

select

asset_id,

asset_name,

case when creator_address = 'UFFXUBZ5DFRLOQOB4LOC7GA3HTWMEEE54U3DJRTL27RKKV4UWOIID3I4FU' then 'Gen 2' else 'Gen 1' end as type

from algorand.asset

where creator_address in (

'X5YPUJ2HTFBY66WKWZOAA75WST5V7HWAGS2346SQFK622VNIRQ5ASXHTGA' -- Gen 1

-- 'UFFXUBZ5DFRLOQOB4LOC7GA3HTWMEEE54U3DJRTL27RKKV4UWOIID3I4FU' -- Gen 2

)

-- and split(asset_name,' ')[0]::string = 'Al'

-- and split(asset_name,' ')[1]::string = 'Goanna'

),

user_nfts as (

select

address,

sum(amount) as nfts

from algorand.account_asset

where asset_id in (select asset_id from nfts)

and amount > 0

group by 1

),

user_bals as (

select

u.address,

u.nfts,

sum(balance) as algo_bals

from user_nfts u join algorand.account a on u.address=a.address

group by 1,2

select

nfts,

count(address) as users

from user_bals