date_trunc('day', block_timestamp) as date,

count(distinct tx_hash) as tx_count,

(sum(iff(status = 'SUCCESS', 1, 0)) / tx_count) * 100 as success_rate

from gnosis.core.fact_transactions

WHERE block_timestamp >= current_date-90

group by 1

),

avg_info as (

select avg(success_rate) as avg_success_rate

from info

select *

from info, avg_info