with
miner_cte as (
select
BLOCK_TIMESTAMP::date date
, miner
from ethereum.core.fact_blocks
)
, before_aug_sep_cte as (
select
distinct
miner
from miner_cte
where date < '2022-08-05'
)
, aug_sep_cte as (
select
distinct
miner
from miner_cte
where date between '2022-08-05' and '2022-09-14'
)
select
case
when b.miner is null then 'New'
else 'Return'
end type
, count(a.miner) miner
from aug_sep_cte a
left join before_aug_sep_cte b using(miner)
group by 1