SELECT
date_trunc('week', a.block_timestamp) as week,
max(DATEDIFF(SECOND, a.block_timestamp, b.block_timestamp)) as MAX_block_time_defference
FROM ethereum.core.fact_blocks a
JOIN ethereum.core.fact_blocks b
on a.BLOCK_NUMBER= b.BLOCK_NUMBER - 1
where week >= '2022-06-01'
group by 1