with transactions as (
select
from_address,
min(block_timestamp) as first_tx
from ethereum.core.fact_transactions
group by from_address
)
select
count(from_address) as new_users
from transactions
where first_tx >= '2022-04-01' -- from April
and first_tx < '2022-09-01' -- to August