0xtoshiGROUP#16
Updated 2024-05-26
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 Cluster as (
SELECT * FROM (VALUES
('0x8fb9be046a0e1d7a7069586a4706e93e39fe5f34'),
('0x1981fee2f81f1dd323e023b119db124dabea396e'),
('0x4f641d6afc45e5de976d91f3ee0c5fce7ce7e11f'),
('0x01362d5923530672d6a887ccdfc8b156cee97824'),
('0xda12b49d10329520be0ee0fb4084e882b786766f'),
('0x99436be04157c939f548abd8e3cae9ce01c7abca'),
('0xc4d18fc7d98f204e393a3045ee9073e87c137e8b'),
('0x0f93149d54461a783c1517b23974113b89e38241'),
('0xeb29cbf4b3d04e003b3c82fbbf45f0c97cab3451'),
('0x123317f544d620465d938789656edfcf9699330f'),
('0x1e1e723fd7d851fc66f47cc4fe2de209d55f4465'),
('0x1171697a3f96a3790e6c265fd1d9f0c601f08f79'),
('0x1946e3e87e3d112d05b28c12b831d03f492d14c3'),
('0xa2cf1a1a6ff5b38889065c41963306a0940f3a4f'),
('0x0700efd158f49f0958d85cdb0b28e1f24fdfb7db'),
('0x5d4d36ced9a3096fb1916fc83675bc3785afc971'),
('0x30d3f805c896d8b6290d7978d7121ff24ce4ab22'),
('0xe6bd578dc88b5b867f2b8e0bd91f9cc120f8a07f'),
('0x2b07bcf9a00da1f739ef112c11947dfbb452a7ef'),
('0x466f0ac408d52e7eb082aca07f2835a0d5b8d89b'),
('0x98e640296317a9f5ab7078ebeb7e685da030a19a')
) t(address) ),
ProjectCount as (
SELECT
SENDER_WALLET,
LISTAGG(PROJECT || ' (' || PROJECT_COUNT || ')', ', ') WITHIN GROUP (ORDER BY project) AS project_list
FROM (
SELECT
SENDER_WALLET,
PROJECT,
COUNT(*) AS PROJECT_COUNT
FROM external.layerzero.fact_transactions_snapshot
WHERE PROJECT IS NOT NULL
QueryRunArchived: QueryRun has been archived