SELECT s.NFT_COLLECTION,
s.buyer AS BUYERS, COUNT(DISTINCT s.tx_id) AS nft_sales
FROM flow.core.ez_nft_sales s
JOIN flow.core.dim_contract_labels c ON s.NFT_COLLECTION = c.EVENT_CONTRACT
WHERE s.MARKETPLACE LIKE 'Gigantik Primary Market'
AND s.price IS NOT NULL
AND s.tx_succeeded = 'true'
GROUP BY 1,2
ORDER BY nft_sales DESC
LIMIT 10