COUNT(DISTINCT CASE WHEN tx_succeeded = TRUE THEN tx_hash END) AS "Successful Transactions",

COUNT(DISTINCT tx_hash) AS "Total Transactions",

ROUND(

COUNT(DISTINCT CASE WHEN tx_succeeded = TRUE THEN tx_hash END) * 100.0 / COUNT(DISTINCT tx_hash),

2

) AS "Success Rate (%)"

FROM near.core.fact_transactions

WHERE block_timestamp >= '2024-01-01' AND block_timestamp < '2025-01-01';