select

asset_name,

asset_id

from algorand.asset

where asset_name like 'Warrior Croc%'

and creator_address in ('A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU', 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')

and asset_deleted = false

),

wallet_hloder_info as (

select

address,

count(asset_id) as number_of_holds

from algorand.account_asset

where asset_id in (select asset_id from wildlife_warriors_asset_info)

and amount = 1

group by address

order by number_of_holds desc

select

count(*) as distribution,

sum(number_of_holds) as number_of_holds,

case

when number_of_holds >= 50 then 'More than 50 NFT holds'

when number_of_holds >= 10 and number_of_holds < 50 then 'Between 10 and 50 NFT holds'

when number_of_holds >= 5 and number_of_holds < 10 then 'Between 5 and 10 NFT holds'

when number_of_holds >= 2 and number_of_holds < 5 then 'Between 2 and 5 NFT holds'

when number_of_holds < 2 then '1 NFT holds'

end as holder_distribution

from wallet_hloder_info

group by holder_distribution

order by number_of_holds desc