SELECT NFT_TO_ADDRESS, NFT_FROM_ADDRESS, COUNT(TX_HASH) AS Amount

FROM base.nft.ez_nft_transfers

WHERE nft_address = LOWER('0xbdb1a8772409a0c5eeb347060cbf4b41dd7b2c62')

GROUP BY 1,2

),

Transfers AS (

SELECT NFT_TO_ADDRESS AS Address, SUM (Amount) AS Balance

FROM Count

GROUP BY 1

UNION ALL

SELECT NFT_FROM_ADDRESS AS Address, SUM (-Amount) AS Balance

FROM Count

GROUP BY 1)

SELECT Address, SUM(Balance) AS "NFT Count"

FROM Transfers

GROUP BY 1

ORDER BY 2 DESC

LIMIT 15