with A as(select
distinct (FROM_ADDRESS) as distinct_user
from arbitrum.core.fact_transactions
where block_timestamp < '2022-07-01')
select
date_trunc('day', block_timestamp) as block_day,
count(distinct FROM_ADDRESS) as new_distinct_user,
CASE
when block_day < '2022-08-31' then 'before nitro upgrade' else 'after nitro upgrade' end as time_category
from arbitrum.core.fact_transactions
where FROM_ADDRESS not in (select distinct_user from A)
and block_day >= '2022-07-01'
group by block_day