SELECT

COUNT(DISTINCT tx_hash) AS successful_txns

FROM kaia.core.fact_transactions

WHERE TX_SUCCEEDED = 'TRUE'

AND Block_timestamp::date >= '2024-01-01'

),

failed_transactions AS (

SELECT

COUNT(DISTINCT tx_hash) AS failed_txns

FROM kaia.core.fact_transactions

WHERE TX_SUCCEEDED != 'TRUE'

AND Block_timestamp::date >= '2024-01-01'

SELECT

(successful_txns / (successful_txns + failed_txns)) * 100 AS txn_success_percentage

FROM failed_transactions, successful_transactions;