date_cte as (

select

distinct

BLOCK_TIMESTAMP::date date

, case

when date < '2022-09-15' then '1. before the merge'

else '2. after the merge'

end period

from ethereum.core.fact_blocks

where 1=1

and BLOCK_TIMESTAMP::date >= '2022-09-01'

and BLOCK_TIMESTAMP::date <= '2022-10-20'

)

select

date

, period

, case

when date < '2022-09-15' then 112/365

else 0.01/365

end energy_consumption

from date_cte