SELECT '0xbc4ca0eda7647a8ab7c2061c2e118a18a936f13d' AS CC, 'Bored Ape Yacht Club' AS Collection UNION

SELECT '0x34d85c9cdeb23fa97cb08333b511ac86e1c4e258', 'Otherdeed for Otherside' UNION

SELECT '0x60e4d786628fea6478f785a6d7e704777c86a7c6', 'Mutant Ape Yacht Club'

),

t3 AS (

SELECT NFT_FROM_ADDRESS AS Sender, count(*) AS sent

FROM ethereum.core.ez_nft_transfers

WHERE NFT_ADDRESS IN (SELECT cc FROM t1)

GROUP BY 1),

t4 AS (

SELECT NFT_TO_ADDRESS AS receiver, count(*) AS Receive

FROM ethereum.core.ez_nft_transfers

WHERE NFT_ADDRESS IN (SELECT cc FROM t1)

GROUP BY 1),

t5 AS(

-- SELECT Minter AS Wallet,mints AS NFT FROM t2

-- UNION ALL

SELECT Sender AS Wallet, sent*(-1) AS NFT FROM t3

UNION ALL

SELECT receiver,Receive FROM t4 ),

t6 AS(

SELECT Wallet, SUM(NFT) AS Number_of_collectibles

FROM t5

Where Wallet !='0x0000000000000000000000000000000000000000'

GROUP BY 1

ORDER BY 2 )