DATE_TRUNC('month', t.block_timestamp) AS month,

t.status,

COUNT(t.tx_hash) AS transaction_count

FROM

avalanche.core.fact_transactions t

GROUP BY

month, t.status

ORDER BY

month;