Yousefi_1994How many unique wallets have Mint Pooly NFT?
Updated 2022-06-22
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
›
⌄
with sooly_supporter as (
select
count(distinct nft_to_address) as number_of_minter
from ethereum.core.ez_nft_mints
where nft_address = '0x90b3832e2f2ade2fe382a911805b6933c056d6ed'
and event_type = 'nft_mint'
and nft_count > 0
),
pooly_lawyer as (
select
count(distinct nft_to_address) as number_of_minter
from ethereum.core.ez_nft_mints
where nft_address = '0x3545192b340f50d77403dc0a64cf2b32f03d00a9'
and event_type = 'nft_mint'
and nft_count > 0
),
pooly_judge as (
select
count(distinct nft_to_address) as number_of_minter
from ethereum.core.ez_nft_mints
where nft_address = '0x5663e3e096f1743e77b8f71b5de0cf9dfd058523'
and event_type = 'nft_mint'
and nft_count > 0
)
select 'Pooly - Supporter' as type, * from sooly_supporter
union
select 'Pooly - Lawyer' as type, * from pooly_lawyer
union
select 'Pooly - Judge' as type, * from pooly_judge
Run a query to Download Data