select block_number

, count(tx_hash) as count_tx_hash

from avalanche.core.fact_transactions

where block_timestamp::date between '2022-01-01' and CURRENT_DATE

and status = 'SUCCESS'

group by 1

select avg(count_tx_hash) as "Average TX per block (#)"

, max(count_tx_hash) as "Max TX per block (#)"

, min(count_tx_hash) as "Min TX per block (#)"

from average