--What's the average number of transactions per block? What's the max number of transactions we've seen in a block and the minimum?
SELECT avg(tx_count) as avg_txns,
max(tx_count) as max_txns,
min(tx_count) as min_txns
FROM avalanche.core.fact_blocks
WHERE block_timestamp::date >= '2022-06-20'