CarlOwOs(2) wallet tags - wallet data
Updated 2022-12-09
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
›
⌄
WITH wallets AS (
SELECT DISTINCT nft_to_address
FROM ethereum.core.ez_nft_mints
WHERE nft_address = lower('0xC178994cB9b66307Cd62dB8b411759Dd36D9C2EE')
),
tags AS (
SELECT
tag_name,
COUNT(DISTINCT address) AS wallet_count
FROM
crosschain.core.address_tags
WHERE
address IN (SELECT * FROM wallets)
AND tag_type in ('wallet')
GROUP BY
1
)
SELECT
tag_name,
wallet_count,
ROW_NUMBER() OVER (ORDER BY wallet_count DESC) AS rank
FROM
tags
ORDER BY wallet_count DESC
LIMIT 10
Run a query to Download Data