KaskoazulIt's the Catalina Whale Mixer - holders
Updated 2022-05-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
with purchasers as (
select sales.purchaser as purchasers,
count (sales.tx_id) as number_sales,
sum (sales.sales_amount) as volume_sales
from flipside_prod_db.solana.fact_nft_sales sales
inner join flipside_prod_db.solana.dim_nft_metadata dat
on sales.mint = dat.mint
where dat.project_name = 'Catalina Whale Mixer'
and sales.succeeded = 'TRUE'
group by 1
order by 1
)
select case
when number_sales < 5 then 'Tier 1'
when number_sales >= 5 and number_sales < 10 then 'Tier 2'
when number_sales >= 10 then 'Tier 3'
end as Tier,
count (purchasers) as wallets
from purchasers
group by 1
order by 2
Run a query to Download Data