MLDZMNSolana whale
Updated 2022-06-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
with tb1 as (select
distinct PURCHASER as buyer_solana,
count(tx_id) as sale_solana
from flipside_prod_db.solana.fact_nft_sales
where succeeded = 'TRUE'
group by 1)
select
case
when sale_solana>=100 then 'Whales: over 100 NFTs' else 'ordinary users'
end as gp,
count(distinct buyer_solana) as users
from tb1
group by 1 having gp is not null
Run a query to Download Data