select

block_id,

block_timestamp as date1,

count(*) as count1

from solana.core.fact_transactions

group by 1,2 )

select

date_trunc('day', date1) as Date_1 ,

avg(count1) as Average_Transactions_Per_Block,

min(count1) as Min_Transactions_Per_Block,

max(count1) as Max_Transactions_Per_Block

from tab1

group by 1