select t2.CONTRACT_NAME as "NFT project",count(distinct TX_ID) as "Total Sales Transactions"
from flow.core.fact_nft_sales as ns
join flow.core.dim_contract_labels as t2
on ns.NFT_COLLECTION=t2.EVENT_CONTRACT
where tx_succeeded = 'TRUE'
group by t2.CONTRACT_NAME
order by "Total Sales Transactions" desc
limit 10