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