select holder_address, count(*) as total_holded_nft from ( select buyer_address as holder_address, tokenid from ( SELECT tokenid,NFT_TO_ADDRESS as buyer_address,

row_number() over (partition by tokenid order by block_timestamp desc) as rank FROM ethereum.core.ez_nft_transfers

WHERE project_name LIKE 'cryptopunks' and NFT_ADDRESS='0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb' ) where rank = 1 and holder_address !='0x0000000000000000000000000000000000000000')

group by holder_address order by total_holded_nft desc limit 10