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

NFT_TO_ADDRESS, NFT_FROM_ADDRESS

),

Transfers AS (

SELECT

NFT_TO_ADDRESS AS Address,

SUM(Amount) AS Balance

FROM

Count

GROUP BY

NFT_TO_ADDRESS

UNION ALL

SELECT

NFT_FROM_ADDRESS AS Address,

SUM(-Amount) AS Balance

FROM

Count

GROUP BY

NFT_FROM_ADDRESS

),

HolderCounts AS (

SELECT

Address,

SUM(Balance) AS NFT_Count

FROM

Transfers

GROUP BY