with transactions as (
select
signers[0] as from_address,
min(block_timestamp) as first_tx
from solana.core.fact_transactions
where succeeded = 'TRUE'
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