--credit jacktheguy
SELECT
address_name,
count(DISTINCT ORIGIN_TO_ADDRESS) as Users
FROM avalanche.core.fact_token_transfers
LEFT outer JOIN avalanche.core.dim_labels
ON address = contract_address
WHERE not address is NULL
GROUP BY 1
ORDER BY 2 DESC
LIMIT 10