COUNT(DISTINCT FACT_NFT_SALES_ID) AS total_nft_sales

FROM

aptos.nft.fact_nft_sales

WHERE

BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP());