SELECT

NFT_TO_ADDRESS AS holder,

SUM(NFT_COUNT) AS total_mints

FROM

aptos.nft.ez_nft_mints

WHERE

PROJECT_NAME = 'Pixel Pirates'

GROUP BY

holder

),

buys AS (

SELECT

BUYER_ADDRESS AS holder,

COUNT(distinct tokenid) AS total_buys

FROM

aptos.nft.ez_nft_sales

WHERE

PROJECT_NAME = 'Pixel Pirates'

GROUP BY

holder

),

sells AS (

SELECT

SELLER_ADDRESS AS holder,

COUNT(distinct tokenid) AS total_sells

FROM

aptos.nft.ez_nft_sales

WHERE

PROJECT_NAME = 'Pixel Pirates'

GROUP BY

holder

),

holder_nfts AS (

SELECT

COALESCE(mints.holder, buys.holder, sells.holder) AS holder,