case

when balance>0 and balance<=10 then 'Shimp'

when balance>10 and balance<=100 then 'Crab'

when balance>100 and balance<=1000 then 'Octopus'

when balance>1000 and balance<=10000 then 'Fish'

when balance>10000 then 'Shark'

end as Distribution

,count(DISTINCT nft_asset_id) as Sold_NFTs

,count(DISTINCT address) as wallets

from algorand.core.fact_account_current_balance

join algorand.nft.ez_nft_sales n on n.PURCHASER = ADDRESS

where _INSERTED_TIMESTAMP::date =CURRENT_DATE-1

and

and balance!=0

and NFT_MARKETPLACE = '{{MarketPlace}}'

group by 1