select asset_id from flipside_prod_db.algorand.asset

where creator_address = 'GOOSE7PN4S366W5LLQ3TRO4BCB2C66VBSMMXRVAWAPGZJHJYR34VNK2AU4'

and total_supply = 1

and decimals = 0

),

holders as (

select

address,

count(distinct asset_id) as number_of_NFTs

from flipside_prod_db.algorand.account_asset

where asset_id in (select asset_id from CFG_asset_id)

and amount > 0

group by 1

select

number_of_NFTs,

count(*) as number_of_holders,

100 * ratio_to_report(number_of_holders) over () as perc,

sum(number_of_holders) over () as total_holders

from holders

group by 1