select asset_id

from flipside_prod_db.algorand.asset

where asset_name like '%Al Goanna%' and asset_deleted = False and creator_address like '%44CA'

),

nft_holder as (

select address

from flipside_prod_db.algorand.account_asset

where asset_id in (select asset_id from Al_Goannas) and amount > 0

select case

when balance > 0 and balance <= 1 then '(0, 1]'

when balance > 1 and balance <= 10 then '(1, 10]'

when balance > 10 and balance <= 100 then '(10, 100]'

when balance > 100 and balance <= 1000 then '(100, 1000]'

when balance > 1000 and balance <= 10000 then '(1,000, 10,000]'

when balance > 10000 and balance <= 100000 then '(10,000, 100,000]'

when balance > 100000 and balance <= 1000000 then '(100,000, 1,000,000]'

else 'more than 1,000,000' end as dis, count(*)

from flipside_prod_db.algorand.account

where balance > 0 and address in (select address from nft_holder)

group by 1