SELECT
CASE
WHEN TX_SUCCEEDED THEN 'successful transactions'
ELSE 'failed transactions'
END AS transaction_status,
COUNT(TX_HASH) AS transaction_count,
COUNT(TX_HASH) * 100.0 / SUM(COUNT(TX_HASH)) OVER () AS transaction_percentage
FROM
monad.testnet.fact_transactions
GROUP BY
transaction_status;