NFT_TO_ADDRESS as holder,

tokenid,

sum(

CASE when NFT_FROM_ADDRESS LIKE '0x0000000000000000000000000000000000000000' then ERC1155_VALUE

when NFT_TO_ADDRESS LIKE '0x0000000000000000000000000000000000000000' then -1 * ERC1155_VALUE

end

) as token_amt

from polygon.core.ez_nft_transfers

WHERE NFT_ADDRESS LIKE lower('0x83C923Ed97a14271610B8125317a85F469a18662')

AND tokenid = 1

and not holder LIKE '0x0000000000000000000000000000000000000000'

GROUP BY 1,2