avg(datediff(second, current_.block_timestamp, lag.block_timestamp)) as avg_blocktime,

min(datediff(second, current_.block_timestamp, lag.block_timestamp)) as min_blocktime,

max(datediff(second, current_.block_timestamp, lag.block_timestamp)) as max_blocktime

from solana.core.fact_transactions as current_

inner join solana.core.fact_transactions as lag on current_.block_id = lag.block_id - 1

where current_.block_timestamp >= current_date - 7