SELECT BLOCK_TIMESTAMP, NFT_ID

FROM flow.core.fact_nft_sales

ORDER BY 1 DESC),

nft2 AS(

SELECT DISTINCT NFT_ID AS NFT_ID

FROM nft)

SELECT PLAY_TYPE, COUNT(m.NFT_ID) AS number

FROM nft2 n JOIN flow.core.dim_topshot_metadata m ON n.NFT_ID = m.NFT_ID

GROUP BY 1

ORDER BY 2 DESC