bachilil nouns
Updated 2022-07-06
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with lilnouns_value as (
select
count(distinct(tx_hash)) as lil_noun_nfts,
'NFT Collection' as nft_collec
from ethereum.core.ez_nft_mints
where nft_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
and tokenid ilike '%1'
),
nounsdao_value as (
select
count(distinct(tx_hash)) as noun_nfts,
'NFT Collection' as nft_collec
from ethereum.core.ez_nft_mints
where nft_address = lower('0x4b10701Bfd7BFEdc47d50562b76b436fbB5BdB3B')
)
select a.lil_noun_nfts, b.noun_nfts, ((a.lil_noun_nfts*100)/b.noun_nfts) as perc_lilnouns_to_nouns
from lilnouns_value a join nounsdao_value b on a.nft_collec = b.nft_collec
Run a query to Download Data