WITH PENGUINS AS
(
SELECT *
FROM ethereum.nft.ez_nft_sales
WHERE NFT_ADDRESS = lower('0xBd3531dA5CF5857e7CfAA92426877b022e612cf8')
AND
BLOCK_TIMESTAMP:: DATE >= '2024-01-01'
)
SELECT
BUYER_ADDRESS,
COUNT (distinct TOKENID) AS N_NFTs
FROM PENGUINS
GROUP BY BUYER_ADDRESS
ORDER BY N_NFTS DESC
LIMIT 10;
;