COUNT(TX_HASH) AS successful_transactions

FROM

bsc.core.fact_transactions;

WHERE

BLOCK_TIMESTAMP BETWEEN '2024-08-01' AND '2024-08-31'

AND STATUS = 'SUCCESS'; -- Assuming 'SUCCESS' indicates a successful transaction