SELECT block_timestamp::DATE AS Dates, COUNT(tx_id) AS "Number of Transaction", COUNT(CASE WHEN SUCCEEDED = true then 1 else null end) as "Number of Success Transaction", COUNT(CASE WHEN SUCCEEDED != true then 1 else null end) as "Total of Transaction Failed", COUNT(DISTINCT signers[0]) as "Number of Users" FROM solana.core.fact_transactions
WHERE block_timestamp::DATE <= CURRENT_DATE - 1 AND block_timestamp::DATE >= '2022-01-01'
GROUP BY Dates
ORDER BY Dates