SELECT
COUNT (DISTINCT (a.TX_ID)) AS sales_number,
SUM (PRICE) AS sales_volume,
AVG (PRICE) AS avg_price,
MAX (PRICE) AS max_price,
MIN (PRICE) AS min_price,
PLAY_TYPE
FROM flow.core.fact_nft_sales a
LEFT JOIN flow.core.dim_topshot_metadata b
ON a.NFT_ID = b.NFT_ID
WHERE a.NFT_COLLECTION = 'A.0b2a3299cc857e29.TopShot' AND TX_SUCCEEDED = 'TRUE' AND PLAY_TYPE IS NOT NULL
GROUP BY PLAY_TYPE