adriaparcerisasShroomDK Mint 4
Updated 2022-07-01
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
›
⌄
with
shroom_minters as (
select
distinct nft_to_address as minters
from ethereum.core.ez_nft_mints
where
nft_address='0xdfb57b6e16ddb97aeb8847386989f4dca7202146' and nft_from_address='0x0000000000000000000000000000000000000000' and event_type ='nft_mint'
group by 1
),
godmode_minters as (
SELECT
distinct nft_to_address as minters
from ethereum.core.ez_nft_mints
where
nft_address='0x903e2f5d42ee23156d548dd46bb84b7873789e44' and nft_from_address='0x0000000000000000000000000000000000000000' and event_type ='nft_mint'
group by 1
),
crossover as (
SELECT
distinct minters
from shroom_minters where minters in (select * from godmode_minters)
)
SELECT
count(distinct x.minters) as shroom_NFT_minters,
count(distinct y.minters) as godmode_NFT_minters,
count(distinct z.minters) as shroom_godmode_minters,
(shroom_godmode_minters/shroom_NFT_minters)*100 as pcg_shroom_minters_that_minted_godmode
from shroom_minters x, godmode_minters y, crossover z
Run a query to Download Data