SUM(SALE_AMOUNT) AS total_sales_volume

FROM aptos.nft.ez_nft_sales

WHERE

MONTH(BLOCK_TIMESTAMP) = 9 -- Filter for September

AND YEAR(BLOCK_TIMESTAMP) = YEAR(CURRENT_DATE()); -- Ensure it's for the current year