AS (SELECT Date_trunc('day', block_timestamp) AS DATE,

Count(date) AS All_Transactions

FROM osmosis.core.fact_transactions

WHERE date > CURRENT_DATE - 121

AND date < CURRENT_DATE

GROUP BY 1),

failedtrans

AS (SELECT Date_trunc('day', block_timestamp) AS dt,

Count(dt) AS Failed_Transactions

FROM osmosis.core.fact_transactions

WHERE dt > CURRENT_DATE - 121

AND dt < CURRENT_DATE

AND tx_status = 'FAILED'

GROUP BY 1)

SELECT date,

Round (( failed_transactions / all_transactions ) * 100, 2) AS

Failure_Percent

FROM alltran

JOIN failedtrans

ON date = dt

ORDER BY 1