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