select
'Success' as type,
count(distinct tx_hash) as transactions
from
boba.core.fact_transactions
where
tx_succeeded
union all
select
'Fail' as type,
count(distinct tx_hash) as transactions
from
boba.core.fact_transactions
where
tx_succeeded = false