'https://flowscan.org/contract/' || s.NFT_COLLECTION AS NFT_COLLECTION,

CASE

WHEN s.NFT_COLLECTION = 'A.329feb3ab062d289.RaceDay_NFT' THEN 'RaceDay_NFT'

WHEN s.NFT_COLLECTION = 'A.329feb3ab062d289.DGD_NFT' THEN 'DGD_NFT'

ELSE NULL

END as NFT_COLLECTIONs ,

'https://flowscan.org/account/' || 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, 3

ORDER BY nft_sales DESC

LIMIT 10;