count(TX_HASH) as "Number of Total Txs",

count(case when STATUS = 'SUCCESS' then TX_HASH end) as "Number of Successful Txs",

("Number of Successful Txs" / "Number of Total Txs")*100 as "Successful Txs Rate",

(100 - "Successful Txs Rate") as "Failed Txs Rate"

from polygon.core.fact_transactions

where (block_timestamp BETWEEN '2023-01-18' AND '2023-01-25')