miner_cte as (

select

BLOCK_TIMESTAMP

, BLOCK_TIMESTAMP::date date

, miner

, block_number block

from ethereum.core.fact_blocks

)

, jul_sep_cte as (

select

distinct

miner

from miner_cte

where date between '2022-07-01' and '2022-09-14'

)

, aug_sep_cte as (

select

distinct

miner

from miner_cte

where date between '2022-08-05' and '2022-09-14'

)

, stop_miner_cte as (

select

miner

from jul_sep_cte

where miner not in (select miner from aug_sep_cte)

)

, time_between_block_cte as (

select

miner

, BLOCK_TIMESTAMP

, datediff(hour, lag_BLOCK_TIMESTAMP, BLOCK_TIMESTAMP) hour_between_block

from (

select