select

date_trunc('week',block_timestamp) as w1,

count(TX_STATUS) as all_transactions

from terra.transactions

where block_timestamp >= '2022-01-01'

group by 1

order by 1),

x2 as (

select

date_trunc('week',block_timestamp) as w2,

count(TX_STATUS) as fail_weekly

from terra.transactions

where block_timestamp >= '2022-01-01'

and TX_STATUS='FAILED'

group by 1

order by 1 )

x1.w1 as wk,

all_transactions,

fail_weekly,

all_transactions-fail_weekly as success_wekly,

(fail_weekly/all_transactions)*100 as failure_rate,

sum(failure_rate) over (ORDER BY wk) as cum_failure_rate

from x1 full outer join x2 on x1.w1=x2.w2

group by 1,2,3,4

order by 1