PS0G1Collections with the least amount of NFTs sold
    Updated 2023-01-06
    select nft_address,
    project_name as collcection,
    count (Distinct tokenid) as Sold_NFTs
    from ethereum.core.ez_nft_sales t1 left outer join ethereum.core.dim_labels t2 on t1.nft_address = t2.address
    where collcection !='opensea' and block_timestamp >= '2022-01-01' and block_timestamp < '2023-01-01'
    group by 1,2
    order by 3 asc
    limit 20
    Run a query to Download Data