date_trunc(week,block_timestamp)::date as date,

case when SUCCEEDED=true then 'SUCCEEDED'

else 'FAILED'

end as status ,

count(tx_id) as num_transactions ,

sum (num_transactions) over (partition by status order by date) as cum_transactions ,

count(DISTINCT signers[0]) as num_wallets

from solana.core.fact_transactions

where block_timestamp::date>=CURRENT_DATE - 180

group by 1,2

),

success as (

select date , num_transactions as success_num_transactions

from all_ where status = 'SUCCEEDED'

),

failed as (

select date , num_transactions as failed_num_transactions

from all_ where status = 'FAILED'

select date ,

(success_num_transactions/(success_num_transactions+failed_num_transactions))*100 as success_rate

from success join failed using (date )

group by 1,2