(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),

Top_NFTs as (SELECT ALL_DAY_NFTs.NFT_ID, Serial_Number, MOMENT_TIER,TOTAL_CIRCULATION ,MOMENT_DESCRIPTION,PLAYER, TEAM, SEASON, WEEK, CLASSIFICATION, Play_Type,

MOMENT_DATE, PRICE "Sale Price ($)" --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 BLOCK_TIMESTAMP::DATE <CURRENT_DATE

ORDER BY "Sale Price ($)" DESC LIMIT 120),

Rank_By_NFT_IDs AS (SELECT NFT_ID, Serial_Number, MOMENT_TIER,TOTAL_CIRCULATION ,MOMENT_DESCRIPTION,PLAYER, TEAM, SEASON, WEEK, CLASSIFICATION, Play_Type,

MOMENT_DATE,"Sale Price ($)", RANK() OVER(PARTITION BY NFT_ID ORDER BY "Sale Price ($)" DESC) Rank

FROM Top_NFTs ORDER BY "Sale Price ($)" DESC ),

Top_100 AS (SELECT NFT_ID, Serial_Number, MOMENT_TIER,TOTAL_CIRCULATION ,"Sale Price ($)",MOMENT_DESCRIPTION,PLAYER, TEAM, SEASON, WEEK, CLASSIFICATION, Play_Type,

MOMENT_DATE FROM Rank_By_NFT_IDs WHERE RANK = '1' ORDER BY "Sale Price ($)" DESC LIMIT 100 )

SELECT Play_Type, COUNT(Play_Type) "Number of valuable NFTs"

FROM Top_100

GROUP BY Play_Type

ORDER BY "Number of valuable NFTs" ASC