, count(tx_id) as tx_counts

, count_if(succeeded = 'TRUE') as success

, count_if(succeeded = 'FALSE') as failure

, success / tx_counts as success_rate

, failure / tx_counts as failure_rate

from solana.core.fact_transactions

where block_timestamp::date between current_date()-61 and current_date()-1

group by 1

order by 1 asc