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