SELECT
PROJECT_NAME AS "NFT Collection",
COUNT(DISTINCT TX_HASH) AS "Total number of sales",
sum(PRICE_USD) AS "Total volume of NFT sales in USD"
/*
sum(TOTAL_FEES) AS "Total volume of purchase fees",
avg(TOTAL_FEES) AS "Average volume of purchase fees",
sum(TOTAL_FEES_USD) AS "Total volume of purchase fees in USD",
avg(TOTAL_FEES_USD) AS "Average volume of purchase fees in USD",
sum(TX_FEE) AS "Total volume of gas fees",
avg(TX_FEE) AS "Average volume of gas fees",
sum(TX_FEE_USD) AS "Total volume of gas fees in USD",
avg(TX_FEE_USD) AS "Average volume of gas fees in USD"
*/
FROM ethereum.core.ez_nft_sales
WHERE origin_to_address = '0xef1c6e67703c7bd7107eed8303fbe6ec2554bf6b' AND PROJECT_NAME IS NOT NULL AND PRICE_USD is NOT NULL
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10