HadisehWorld Cup 3
Updated 2022-12-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
›
⌄
with t1 as ( select buyer,
count(DISTINCT tx_id) as total_transaction,
sum(price) as total_usd_vol
from flow.core.ez_nft_sales
where nft_collection = 'A.87ca73a41bb50ad5.Golazos'
and TX_SUCCEEDED = 'TRUE'
group by buyer
order by total_transaction desc
limit 10)
,
t2 as ( select seller,
count(DISTINCT tx_id) as total_transaction,
sum(price) as total_usd_vol
from flow.core.ez_nft_sales
where nft_collection = 'A.87ca73a41bb50ad5.Golazos'
and TX_SUCCEEDED = 'TRUE'
group by seller
order by total_transaction desc
limit 10)
select 'Buyer' as type,
buyer as user,
total_transaction,
total_usd_vol
from t1
UNION
select 'Seller' as type,
seller as user,
total_transaction,
total_usd_vol
from t2
Run a query to Download Data