(SELECT NFT_COLLECTION, NFT_ID, NFLALLDAY_ID,Serial_Number ,MOMENT_TIER ,TOTAL_CIRCULATION,MOMENT_DESCRIPTION,PLAYER, TEAM, SEASON, WEEK,

CLASSIFICATION, Play_Type,MOMENT_DATE FROM flow.core.dim_allday_metadata WHERE Player = 'Patrick Mahomes II' )

SELECT BLOCK_TIMESTAMP::DATE AS DAYS, COUNT(*) "Number of NFTs sold"--TX_ID, MARKETPLACE, BUYER, SELLER, PRICE, CURRENCY, ALL_DAY_NFTs.*

FROM flow.core.ez_nft_sales AS SALES

JOIN ALL_DAY_NFTs ON (SALES.NFT_COLLECTION = ALL_DAY_NFTs.NFT_COLLECTION AND SALES.NFT_ID = ALL_DAY_NFTs.NFT_ID)

WHERE SALES.TX_SUCCEEDED ='TRUE' AND PLAYER != 'N/A' AND DAYS BETWEEN '2022-09-06' AND '2022-09-22'

GROUP BY DAYS