SELECT
COUNT(*) as total_secondary_sales,
SUM(PRICE) as total_sales_in_eth,
SUM(PRICE_USD) as total_sales_in_usd,
SUM(CREATOR_FEE) as creator_commission_in_eth,
SUM(CREATOR_FEE_USD) as creator_commission_in_usd
FROM
ethereum.nft.ez_nft_sales
WHERE
NFT_ADDRESS = '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270'
AND TOKENID LIKE '78000___'
AND SELLER_ADDRESS != '0x33c9371d25ce44a408f8a6473fbad86bf81e1a17';