with a as(select
block_timestamp::date as date,count(tx_id) t1
from solana.core.fact_transactions where date >= CURRENT_DATE - 365 and succeeded = 'TRUE'
group by date
),b as(
select
block_timestamp::date as date,count(tx_id) t2
from solana.core.fact_transactions where date >= CURRENT_DATE - 365 and succeeded = 'FALSE'
group by date
)
select
(t1/(t1+t2)) rate,a.date
from a join b on a.date=b.date