COUNT(DISTINCT TX_HASH) AS transactions,

COUNT(DISTINCT FROM_ADDRESS) AS users,

SUM(TX_FEE_PRECISE) AS fee,

COUNT(DISTINCT CASE WHEN TX_SUCCEEDED THEN TX_HASH END) AS successful_transactions,

COUNT(DISTINCT CASE WHEN NOT TX_SUCCEEDED THEN TX_HASH END) AS failed_transactions,

(COUNT(DISTINCT CASE WHEN TX_SUCCEEDED THEN TX_HASH END) * 100.0 / COUNT(DISTINCT TX_HASH)) AS success_rate

FROM

berachain.testnet.fact_transactions

WHERE

BLOCK_TIMESTAMP::date >= current_date - 30;