DATE_TRUNC('week', block_timestamp) AS date,

TX_SUCCEEDED, count(TX_SUCCEEDED) as count_succeeded_failed

from terra.core.fact_transactions

group by date, TX_SUCCEEDED

select date,

sum(case when TX_SUCCEEDED = 'TRUE' then count_succeeded_failed end) as total_Succeeded,

sum(case when TX_SUCCEEDED = 'FALSE' then count_succeeded_failed end) as total_Failed,

total_Succeeded / (total_Failed + total_Succeeded) * 100 as percentage

from succeeded_date

group by date

order by date DESC