MLDZMNbag7
Updated 2022-10-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with tb1 as (select
distinct purchaser as sender,
marketplace
from solana.core.fact_nft_sales
where SUCCEEDED='TRUE'
and marketplace in ('hyperspace')
group by 1,2)
select
marketplace,
count(distinct purchaser) as no_buyers
from solana.core.fact_nft_sales
where SUCCEEDED='TRUE'
and marketplace not in ('hyperspace','coral cube')
and purchaser in (select sender from tb1)
group by 1
order by 2 desc
Run a query to Download Data