count(distinct(tx_hash)) as n_tx

from optimism.core.fact_transactions

),

succes as (select

count(distinct(tx_hash)) as succes_tx

from optimism.core.fact_transactions

where status = 'SUCCESS'

select

s.succes_tx/t.n_tx as succes_ratio

from tx t, succes s