princefarzamPercentage of fail transactions for Solana since Apr 2022
    Updated 2022-07-21
    SELECT
    'SOLANA' AS PROTOCOL_NAME,
    (SELECT
    COUNT(DISTINCT tx_id) as Number_of_false_txns
    FROM solana.fact_transactions
    WHERE block_timestamp::DATE >= '2022-04-01'
    AND SUCCEEDED = FALSE ) AS Number_of_false_txns,
    (SELECT
    COUNT(DISTINCT tx_id) as Number_of_all_txns
    FROM solana.fact_transactions
    WHERE block_timestamp::DATE >= '2022-04-01') AS Number_of_all_txns,
    (Number_of_false_txns/Number_of_all_txns)*100 AS Percentage_of_txns_that_fail

    Run a query to Download Data