date_trunc('month', block_timestamp),

count_if(succeeded = 'TRUE') as Succeed,

count_if(succeeded = 'FALSE') as Fail

from solana.core.fact_transactions

where block_timestamp > current_date - 365

group by 1