WITH block_data AS (
SELECT DATEDIFF(second, LAG(block_timestamp) OVER(ORDER BY block_height), block_timestamp) AS time_blocks
, tx_count
FROM solana.core.fact_blocks
--WHERE block_timestamp >= CURRENT_DATE - 5
)
SELECT AVG(time_blocks)
, MIN(time_blocks)
, MAX(time_blocks)
, AVG(tx_count)
, MIN(tx_count)
, MAX(tx_count)
FROM block_data