Sbhn_NPcontinued-olive
Updated 2025-02-17
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- WITH
-- TotalTransactionSummary AS (
-- SELECT
-- COUNT(*) AS total_transactions,
-- COUNT(CASE WHEN SUCCESSFUL THEN 1 END) AS successful_transactions,
-- COUNT(CASE WHEN SUCCESSFUL = 'FALSE' OR SUCCESSFUL IS NULL THEN 1 END) AS failed_transactions
-- FROM stellar.core.fact_transactions
-- )
-- SELECT
-- total_transactions,
-- successful_transactions,
-- failed_transactions,
-- (successful_transactions / total_transactions)*100 AS success_rate
-- FROM TotalTransactionSummary
select successful,
count(DISTINCT transaction_hash) as txs
from stellar.core.fact_transactions
group by 1