SELECT

BUYER_ADDRESS,

COUNT(DISTINCT TOKENID) AS TOTAL_NFT_HELD

FROM

aptos.nft.ez_nft_sales

WHERE

PROJECT_NAME = 'The Loonies'

AND block_timestamp >= DATEADD({{Period}}, -1, CURRENT_DATE)

GROUP BY

BUYER_ADDRESS

),

Top10Holders AS (

SELECT

BUYER_ADDRESS,

TOTAL_NFT_HELD

FROM

HolderDistribution

ORDER BY

TOTAL_NFT_HELD DESC

LIMIT 10

),

OtherHolders AS (

SELECT

'Other' AS BUYER_ADDRESS,

SUM(TOTAL_NFT_HELD) AS TOTAL_NFT_HELD

FROM

HolderDistribution

WHERE

BUYER_ADDRESS NOT IN (SELECT BUYER_ADDRESS FROM Top10Holders)

SELECT * FROM Top10Holders

UNION ALL

SELECT * FROM OtherHolders

ORDER BY TOTAL_NFT_HELD DESC;