SELECT SUM(Sales_Volume) AS Total_Sales_Volume_July
FROM (
SELECT DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Sale_Date, COUNT(*) AS Sales_Volume
FROM near.nft.ez_nft_sales
WHERE BLOCK_TIMESTAMP >= '2024-07-01' AND BLOCK_TIMESTAMP < '2024-08-01'
GROUP BY Sale_Date
) AS July_Sales;