yasmin-n-d-r-hbaraye badi
Updated 2022-07-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
›
⌄
SELECT DISTINCT
'total fees for transactions',
(SELECT
SUM(fee)/POW(10,9)
FROM
solana.core.fact_transactions
WHERE
block_timestamp >= '2022-01-01'
AND succeeded='TRUE'
) AS total_fees_for_true_tx,
(SELECT
SUM(fee)/POW(10,9)
FROM
solana.core.fact_transactions
WHERE
block_timestamp >= '2022-01-01'
AND succeeded='FALSE'
) AS total_fees_for_false_tx
FROM solana.core.fact_transactions
Run a query to Download Data