flipside

    #3 AvsB Query: success rate - Binance Smart Chain
    zakkisyed#3 AvsB Query: success rate - Binance Smart Chain
    Updated 2023-04-14
    SELECT count(DISTINCT (tx_hash))
    ,CASE
    WHEN STATUS = 'SUCCESS'
    THEN 'successful transactions'
    ELSE 'failed transactions'
    END AS STATUS
    FROM bsc.core.fact_transactions
    WHERE block_timestamp >= CURRENT_DATE - 7
    GROUP BY 2

    Run a query to Download Data