COUNT(tx_id) as transactions,

COUNT(tx_id)/86400 as TPS_last_month,

(COUNT( CASE

WHEN succeeded = 'TRUE' THEN succeeded ELSE NULL END)/86400)/TPS_last_month AS success_rate

FROM solana.core.fact_transactions

-- last month

WHERE block_timestamp :: date >= '2022-06-13'

GROUP BY day