kingharald-ethNfl team
Updated 2022-09-09
9
1
2
3
4
5
6
7
›
⌄
select team, 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 team
order by tx_num desc
Run a query to Download Data