COUNT(*) AS total_transactions,

COUNT(CASE WHEN STATUS = 'success' THEN 1 END) AS successful_transactions

base.core.fact_transactions;

BLOCK_TIMESTAMP >= '2023-09-01' AND BLOCK_TIMESTAMP < '2023-10-01';