Date_trunc('Day',BLOCK_TIMESTAMP)::DATE AS DAY,

case when TX_SUCCEEDED=TRUE then 'successed' else 'Failed' end AS Result,

Count(*) AS TX

from berachain.testnet.fact_transactions

group by 1,2