-- forked from c1893b55-2ebd-490b-914f-279c92c28488
SELECT
active_weeks,
count(DISTINCT from_address) as users
FROM (
SELECT
from_address,
count(DISTINCT tx_hash) as transaction,
count(DISTINCT date_trunc('week', block_timestamp)) as active_weeks
-- count(DISTINCT to_address) as contracts_interacted_with
from base.goerli.fact_transactions
GROUP BY 1
)
GROUP BY 1
--a