WITH block_txs as (
SELECT distinct BLOCK_NUMBER,
count(tx_hash) as n_txs_per_block
FROM avalanche.core.fact_transactions
WHERE block_timestamp >= '2022-06-20'
GROUP BY 1
ORDER BY 1)
SELECT
min(n_txs_per_block) as min_txs_per_block,
max(n_txs_per_block) as max_txs_per_block
FROM block_txs