select

date_trunc('day', block_timestamp),

count(*) as count1

from optimism.core.fact_transactions

where block_timestamp between '2022-11-06' and '2022-12-14'

group by 1

)

select

avg(count1) as Average_Transactions_Daily,

median(count1) Median_Transactions_Daily,

min(count1) Min_Transactions_Daily,

max(count1) Max_Transactions_Daily

from tab1