--0xba5e05cb26b78eda3a2f8e3b3814726305dcac83
SELECT COUNT(TX_HASH) AS "Sales Count",
CASE WHEN NFT_ADDRESS = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83' THEN 'BasePaint' ELSE PROJECT_NAME END AS "Project Name",
FROM base.nft.ez_nft_sales
WHERE BLOCK_TIMESTAMP >= '2024-01-01' AND
BLOCK_TIMESTAMP<='2024-06-30'
GROUP BY PROJECT_NAME, NFT_ADDRESS
ORDER BY 1 DESC
LIMIT 10