avg(new_users),

sum(new_users)

FROM (

SELECT

first_day as day,

count(DISTINCT to_address) as new_users

FROM (

SELECT

to_address,

min(date_trunc('day', block_timestamp)) as first_day

from base.goerli.fact_transactions

WHERE not to_address in (SELECT from_address FROM base.goerli.fact_transactions)

GROUP BY 1

)

GROUP BY 1