select play_type, team, count(distinct(tx_id)) as tx_num from flow.core.ez_nft_sales a
join flow.core.dim_allday_metadata b
on a.nft_collection = b.nft_collection
where tx_succeeded = 1
and a.nft_collection = 'A.e4cf4bdc1751c65d.AllDay'
group by play_type, team