SELECT *

FROM avalanche.core.dim_labels

WHERE label_type = 'nft'

),

txs AS (

SELECT *

FROM avalanche.core.fact_event_logs

WHERE tx_status = 'SUCCESS'

SELECT

n.project_name AS "Project",

COUNT(DISTINCT t.origin_from_address) AS "Users"

FROM nft n

JOIN txs t ON n.address = t.contract_address

GROUP BY 1

ORDER BY 2 DESC