SELECT

STATUS,

COUNT(*) AS total_transactions

FROM

base.core.fact_transactions;

WHERE

BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP())

AND BLOCK_TIMESTAMP < CURRENT_TIMESTAMP()

GROUP BY

STATUS

),

Successful_Transactions_Last_30_Days AS (

SELECT

total_transactions AS successful_transactions

FROM

Transactions_Last_30_Days

WHERE

STATUS = 'SUCCESS'

),

Total_Transactions_Last_30_Days AS (

SELECT

SUM(total_transactions) AS total_transactions

FROM

Transactions_Last_30_Days

total_transactions,

successful_transactions,

ROUND((successful_transactions / NULLIF(total_transactions, 0)) * 100, 2) AS percentage_successful

FROM

Successful_Transactions_Last_30_Days,

Total_Transactions_Last_30_Days;