SELECT

COUNT(*) AS total_transactions,

COUNT(CASE WHEN TX_SUCCEEDED = TRUE THEN 1 END) AS successful_transactions,

COUNT(CASE WHEN TX_SUCCEEDED = FALSE THEN 1 END) AS failed_transactions

FROM boba.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= '2025-01-01'

SELECT

'Transaction Outcome' AS Sucess_vs_Failure ,

successful_transactions * 100.0 / NULLIF(total_transactions, 0) AS total_success_rate,

failed_transactions * 100.0 / NULLIF(total_transactions, 0) AS total_failure_rate

FROM TransactionSummary;