SELECT

COUNT(TX_HASH) AS total_tx

FROM

bsc.core.fact_transactions

WHERE

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

),

successful_transactions AS (

SELECT

COUNT(TX_HASH) AS successful_tx

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

SELECT

(successful_tx / total_tx::FLOAT) * 100 AS success_percentage

FROM

total_transactions, successful_transactions;