with base as (select block_id,
count(distinct(tx_id)) as count_tx
from solana.core.fact_transactions
where block_timestamp >= '2022-06-01'
group by 1)
select avg(count_tx) as "Transaction per Block",
'Average TX per Block' as "Min, Avg and Max"
from base
union
select max(count_tx),
'Max TX per Block'
from base
union
select min(count_tx),
'Min TX per Block'
from base
order by 1 asc