select date(s.block_timestamp) dt
, d.team playoff_teams
, count(distinct s.tx_id) sales_ct
from flow.core.fact_nft_sales s
inner join flow.core.dim_topshot_metadata d
on s.nft_id = d.nft_id
where s.tx_succeeded = TRUE
and s.nft_collection = 'A.0b2a3299cc857e29.TopShot'
and d.team in ('Golden State Warriors', 'Boston Celtics', 'Dallas Mavericks', 'Miami Heat')
group by 1,2