select date_trunc('day', block_timestamp) as date, (sum(iff(status = 'SUCCESS', 1, 0)) / count(*)) * 100 as success_rate

from optimism.core.fact_transactions

where date between '2022-07-01' and '2022-07-31'

group by 1

),

avg_rate as (

select avg(success_rate) as avg_success_rate

from rate

select * from rate, avg_rate