SELECT project_name,

Count(DISTINCT tx_hash) AS total_txs_count,

Count(DISTINCT origin_to_address) AS no_of_users,

Count(DISTINCT address) AS no_of_nfts_sold

FROM (SELECT *

FROM avalanche.core.dim_labels

INNER JOIN avalanche.core.fact_event_logs

ON contract_address = address)

WHERE label_type = 'nft'

GROUP BY 1

ORDER BY 2 DESC