with txs as (
select count (tx_hash) total
from berachain.testnet.fact_transactions
)
select
case when TX_SUCCEEDED = true then 'Successful transactions'
when TX_SUCCEEDED = false then 'Failed transactions '
end type ,
(count(tx_hash) / total )*100 percent
from berachain.testnet.fact_transactions , txs
group by 1 , total