0xtoshigroup#5
Updated 2024-05-28
999
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
('0xf1971d6d63cae2bb6aeacbacb7aa676c0c834ca2'),
('0xf1094c78ae812ef0c37f55f20448a3ee32a8748f'),
('0xc68988d2042b98e647121cd7b7fe31ae92edd6b9'),
('0xbb8846a98a1867efe0fb126b9add661bccfed0cc'),
('0xb999b17976e0187d1b7d7bf4bdbc849f015e1dde'),
('0xb04130bc7a61084bf4023275e774aa126126ede8'),
('0xa39862542e29f93cff498147ee6c5310ae488486'),
('0xa1c64be9dae6eab20ee677d94ebbd94f66649375'),
('0x9077557aee71f204cb25151407969628d8e15979'),
('0x88e70e87e9565af9d88b5377179ec0104117fd6e'),
('0x877720f5c1e726eb86ee80bb19aac356b9b1895a'),
('0x7c954d23bf8505f37c7587ffeee7cde07f509261'),
('0x741c5fce3757f6be5907435fc000971e71f7d74a'),
('0x737f83006825d994eae1cb709e8ec269c471f8e3'),
('0x7028331f972bf2dd3582420c7c2400515d079a9a'),
('0x51785ab9d0068d55f5f9ae1603f94f70915fca4e'),
('0x4dba3976ba12a03019d10db3443b2ea3551cd4db'),
('0x42f208531dcc5f9f9bce7ed4d56ebbc730938505'),
('0x3ffedf1112b6da920fc40cfbd4a60c653ec0da24'),
('0x3baa092f023bdefde8b1df0a438073eb27eba4cb'),
('0x214dbfa1012690eb0b5f042dc37dab86a2e5ebd0'),
('0x19472843093974a855b7c703f8379b3f5b467daf')
) 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
QueryRunArchived: QueryRun has been archived