date_trunc('month',BLOCK_TIMESTAMP) as month ,

TX_STATUS ,

count( TX_STATUS) as num

FROM near.core.fact_transactions

where BLOCK_TIMESTAMP::date< '2022-11-01'

GROUP by TX_STATUS, month