with tab1 as (
select
min(date_trunc('week', block_timestamp)) as date1,
from_address
from optimism.core.fact_transactions
group by 2
)
select
date1,
Case
when date1 between '2022-11-06' and '2022-12-14'
then 'Sudden Drop/Slow Climb Period'
else 'Normal'
END as Drop_Period,
count(*)
from tab1
group by 1 ,2