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