((select count(distinct tx_hash) from kaia.core.fact_transactions

where tx_succeeded = 1

/ (select count(distinct tx_hash) from kaia.core.fact_transactions )) * 100 as success_rate