select

block_timestamp,

tx_status

from osmosis.core.fact_transactions

where BLOCK_TIMESTAMP>=CURRENT_DATE - INTERVAL '4 MONTHS'

)

trunc(block_timestamp,'day') as date,

sum(case when tx_status='FAILED' then 1 end ) as failed_txs,

sum(case when tx_status='SUCCEEDED' then 1 end) as succeded_txs,

failed_txs+succeded_txs as total_txs,

failed_txs/total_txs as failed_rate,

1-failed_rate as succeeded_rate

from fees

group by 1

order by 1 asc