MLDZMNportal5
Updated 2022-12-23
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
›
⌄
with tb1 as (
select
Label,
ADDRESS as mints
from solana.core.dim_labels
where LABEL ilike '%portals%'),
tb3 as (select
purchaser as minter
from solana.core.fact_nft_mints x
left join tb1 a on x.mint=a.mints
where mint in (select mints from tb1)
and label!='portals.art'
)
select
Project_NAME as NFTs,
count(distinct PURCHASER) as no_minters
from solana.core.fact_nft_mints a left outer join solana.core.DIM_NFT_METADATA b on a.mint=b.mint
where PURCHASER in (select minter from tb3)
and SUCCEEDED='TRUE'
group by 1 having NFTs is not null
order by 2 desc
limit 10
Run a query to Download Data