SELECT

nft_from_address AS original_minter,

tokenid,

COUNT(*) AS transaction_count

FROM base.nft.ez_nft_transfers

WHERE event_type = 'mint'

GROUP BY nft_from_address, tokenid

),

ResaleActivity AS (

SELECT

nft_from_address,

tokenid,

COUNT(*) AS resale_count

FROM ethereum.nft.ez_nft_transfers

WHERE event_type IN ('sale', 'transfer') AND nft_from_address NOT IN ('0x0000000000000000000000000000000000000000')

GROUP BY nft_from_address, tokenid

ma.original_minter,

COUNT(DISTINCT ma.tokenid) AS total_minted,

COALESCE(SUM(ra.resale_count), 0) AS total_resold

FROM MinterActivity ma

LEFT JOIN ResaleActivity ra ON ma.original_minter = ra.nft_from_address AND ma.tokenid = ra.tokenid

GROUP BY ma.original_minter

ORDER BY total_resold DESC;