kaibladeUntitled Query
Updated 2022-06-23
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 all_holders as (
SELECT
nft_from_address as address,
'-1' as nft_count
FROM ethereum.core.ez_nft_transfers
WHERE nft_address IN (lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'),
lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'),
lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'))
UNION ALL
SELECT
nft_to_address as address,
'1' as nft_count
FROM ethereum.core.ez_nft_transfers
WHERE nft_address IN (lower('0x90B3832e2F2aDe2FE382a911805B6933C056D6ed'),
lower('0x3545192b340F50d77403DC0A64cf2b32F03d00A9'),
lower('0x5663e3E096f1743e77B8F71b5DE0CF9Dfd058523'))
)
,
holders AS (SELECT
address,
SUM(nft_count) as holdings
FROM all_holders
GROUP BY address
HAVING holdings > 0
)
SELECT ((SELECT COUNT(address) FROM holders WHERE holdings < 2)) AS has_one_pooly,
((SELECT COUNT(address) FROM holders WHERE holdings >= 2)) AS has_multiple_pooly
UNPIVOT
(
NFTS for groupings in (5510, 434)
) as UnPvt
Run a query to Download Data