-- forked from 0959e3a3-2aa0-4e66-b96d-1e5e0aa7554a
SELECT
to_address,
count(DISTINCT tx_hash) as transactions,
count(DISTINCT date_trunc('day', block_timestamp)) as active_days
-- count(DISTINCT to_address) as contracts_interacted_with
from base.goerli.fact_transactions
WHERE not to_address in (SELECT from_address FROM base.goerli.fact_transactions)
GROUP BY 1
ORDER BY 2 DESC
LIMIT 100