bachiavalanche8
    Updated 2023-04-13
    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 project_name
    ORDER BY total_txs_count DESC
    limit 10
    Run a query to Download Data