Ali3NSardinhas Purchasers Crossver with Claynosaurz
Updated 2023-03-21
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
32
33
34
35
36
›
⌄
with claynosaurzt as (select * from solana.core.dim_labels where label = 'claynosaurz'),
claymakerst as (select * from solana.core.dim_labels where label = 'claynosaurz claymaker'),
clayt as (select * from solana.core.dim_labels where label = 'claynosaurz: clay'),
sardinhast as (select * from solana.core.dim_labels where label ilike 'sardinhas'),
claynosaurzt1 as (
select distinct purchaser
from solana.core.fact_nft_sales
where mint in (select address from claynosaurzt)
and succeeded = 'TRUE'),
claymakerst1 as (
select distinct purchaser
from solana.core.fact_nft_sales
where mint in (select address from claymakerst)
and succeeded = 'TRUE'),
clayt1 as (
select distinct purchaser
from solana.core.fact_nft_sales
where mint in (select address from clayt)
and succeeded = 'TRUE'),
sardinhast1 as (
select distinct purchaser
from solana.core.fact_nft_sales
where mint in (select address from sardinhast)
and succeeded = 'TRUE')
select 'Purchased All 4 Projects' as type,
count (distinct purchaser)
from claynosaurzt1
where purchaser in (select distinct purchaser from claymakerst1)
Run a query to Download Data