adambala Holders
Updated 2023-05-16
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
›
⌄
with
a as (
select
nft_to_address as wallets,
'1' as flag
FROM ethereum.nft.ez_nft_transfers
where (nft_address =lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')
)
union all
SELECT
nft_from_address as wallets,
'-1' as flag
FROM ethereum.nft.ez_nft_transfers
where (nft_address =lower('0x960b7a6bcd451c9968473f7bbfd9be826efd549a')
)
),
b as (
select
wallets ,
sum(flag) as nfts
from a
group by 1
having 2 > 0
order by 2 desc)
select wallets,nfts
from b where nfts !='0' and nfts>0 order by 2 desc
Run a query to Download Data