date_trunc('week', block_timestamp) as week,

count(BLOCK_NUMBER) as blocks_numbers,

lag( blocks_numbers) ignore nulls over(order by week asc) as delay_block_numbers

from ethereum.core.fact_blocks

where week >='2022-06-01'

group by 1