date_trunc('day', block_timestamp) as "Day",

sum(iff(status = 'SUCCESS', 1, 0))/count(distinct tx_hash) as "Success rate",

sum(iff(status = 'FAIL', 1, 0))/count(distinct tx_hash) as "Failed rate"

from avalanche.core.fact_transactions

group by 1

),

avg_info as (

select avg("Failed rate") as "AVG Failed rate",

avg("Success rate") as "AVG Success rate"

from info

select *

from info, avg_info