address_name,

count(DISTINCT ORIGIN_FROM_ADDRESS) as users

FROM avalanche.core.fact_event_logs

LEFT OUTER JOIN avalanche.core.dim_labels

ON address = CONTRACT_ADDRESS

where not address is NULL

AND not label_subtype LIKE '%token%'

GROUP by 1

ORDER by 2 DESC

LIMIT 10