select

date_trunc('week', block_timestamp) as week,

count(distinct tx_id) as txn_count,

(sum(iff(tx_succeeded = 1, 1, 0)) / txn_count) * 100 as success_rate,

100 - success_rate as fail_rate

from terra.core.fact_transactions

group by week

select avg (txn_count) as average_tx_count,

avg(success_rate) as avg_success_rate,

100 - avg_success_rate as avg_fail_rate

from t