select TOKENID, NFT_ADDRESS , max(BLOCK_TIMESTAMP) as BLOCK_TIMESTAMP_

from ethereum.core.ez_nft_transfers

where NFT_ADDRESS in ('0x90b3832e2f2ade2fe382a911805b6933c056d6ed'-- Pooly - Supporter 3,650 remaining of 10,000

, '0x3545192b340f50d77403dc0a64cf2b32f03d00a9' -- Pooly - Lawyer 712 remaining of 1,000

, '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523'--Pooly - Judge 9 remaining of 10

) GROUP by 1,2

, holder_address as (

select a.TOKENID, a.NFT_ADDRESS , a.NFT_TO_ADDRESS as holder

from ethereum.core.ez_nft_transfers a JOIN holder b on (a.TOKENID = b.TOKENID and a.NFT_ADDRESS = b.NFT_ADDRESS and a.BLOCK_TIMESTAMP = b.BLOCK_TIMESTAMP_ )

)

select avg(nfns) from (

select holder , count(tokenid) as nfns from holder_address group by holder )