Voicedinappropriate-turquoise
    Updated 2024-10-25
    (
    SELECT
    'Total succeed transactions' as label,
    count (DISTINCT tx_hash) as "Total transactions"
    FROM
    berachain.testnet.fact_transactions
    where
    TX_SUCCEEDED = 'TRUE'
    )

    union all

    (
    SELECT
    'Total failed transactions' as label,
    count (DISTINCT tx_hash) as "Total transactions"
    FROM
    berachain.testnet.fact_transactions
    where
    TX_SUCCEEDED = 'FALSE'
    )
    QueryRunArchived: QueryRun has been archived