0xaiman2023-02-11 10:43 PM
Updated 2023-05-05
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
a as (
select
TOKENID,
max(block_timestamp) as tm
from
ethereum.core.ez_nft_transfers
where
nft_address = '0xeb0ddc0579cf3894c78ae2c4a7d5ec3b36bfa13a'
group by
1
),
b as (
select
NFT_TO_ADDRESS,
count(distinct a.tokenid) as n_nft_own
from
ethereum.core.ez_nft_transfers b
inner join a on a.tm = b.block_timestamp
and b.tokenid = a.tokenid
where
nft_address = '0xeb0ddc0579cf3894c78ae2c4a7d5ec3b36bfa13a'
group by
1
)
select
case
when n_nft_own <= 5 then 'Owns 1 - 5 NFTs'
when n_nft_own > 5
and n_nft_own < 11 then 'Owns 6 - 10 NFTs'
when n_nft_own > 10
and n_nft_own < 21 then 'Owns 11 - 20 NFTs'
when n_nft_own > 20
and n_nft_own < 51 then 'Owns 20 - 50 NFTs'
when n_nft_own > 50
and n_nft_own < 101 then 'Owns 50 - 100 NFTs'
Run a query to Download Data