with solana_data as (select block_timestamp as date1,
lag (block_timestamp) over (order by block_timestamp) as date2,
datediff (second,date2,date1) as Diff
from solana.core.fact_blocks),
solana as (select avg(Diff) as Average_Time,
min(Diff) as Minimum_Time,
max(Diff) as Maximum_Time
from solana_data)
select * from solana