with terra_txns as (
SELECT
COUNT(CASE WHEN tx_status='SUCCEEDED' THEN tx_id ELSE NULL END) as stotals,
COUNT(CASE WHEN tx_status!='SUCCEEDED' THEN tx_id ELSE NULL END) as ftotals,
COUNT(tx_id) as totals,
date_trunc('day', block_timestamp) as ddate
from terra.transactions
WHERE
block_timestamp>='2022-01-01'
GROUP BY ddate ORDER BY ddate ASC
)
SELECT
ddate,
(ftotals/totals)*100 as failure_rate,
stotals as successful_txns,
ftotals as failed_txns
from terra_txns