SELECT block_timestamp::DATE AS date
, CASE
WHEN date BETWEEN '2022-05-17' AND '2022-05-29' THEN 'Conference Finals'
WHEN date BETWEEN '2022-04-16' AND '2022-05-16' THEN 'Playoffs'
ELSE 'Off-season' END AS phase
, COUNT(DISTINCT tx_id) AS sales
FROM flow.core.fact_nft_sales
WHERE nft_collection = 'A.0b2a3299cc857e29.TopShot'
AND date between '2022-04-16' and '2022-06-15'
AND tx_succeeded = TRUE
GROUP BY 1