SELECT SUM(PRICE) AS "Total Sell", PLAYER
FROM flow.core.dim_topshot_metadata mtdt
JOIN flow.core.fact_nft_sales nft
ON mtdt.NFT_ID = nft.NFT_ID AND nft.NFT_COLLECTION = mtdt.NFT_COLLECTION
WHERE TEAM ILIKE '%Warriors%' OR TEAM ILIKE '%Celtics%' OR TEAM ILIKE '%Mavericks%' OR TEAM ILIKE '%Heat%' AND BLOCK_TIMESTAMP::DATE BETWEEN '2022-05-17' AND '2022-05-29'
GROUP BY 2
ORDER BY 1 DESC