CASE

WHEN TX_SUCCEEDED = TRUE THEN 'Successful'

WHEN TX_SUCCEEDED = FALSE THEN 'Failed'

END AS transaction_status,

COUNT(DISTINCT TX_HASH) AS total_transactions

FROM boba.core.fact_transactions

WHERE BLOCK_TIMESTAMP >= '2024-01-01'

GROUP BY transaction_status