SELECT DISTINCT
'total fees for transactions',
(SELECT
SUM(fee)/POW(10,9)
FROM
solana.transactions
WHERE
block_timestamp >= '2022-01-01'
AND succeeded='TRUE'
) AS total_fees_for_true_tx,
(SELECT
SUM(fee)/POW(10,9)
FROM
solana.transactions
WHERE
block_timestamp >= '2022-01-01'
AND succeeded='FALSE'
) AS total_fees_for_false_tx
FROM solana.transactions