0xtoshiGROUP#15
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
('0xffc14f81b728816a733f13102d5f5734518fe45d'),
('0xfb7c81ce77cdbb5f78e533822100d53c277e5e9a'),
('0xf9ea68c23ecc8b8beeb51d503d86a0879df3cb77'),
('0xf0d50f861e7971e40886af0f59571998cd8bed8f'),
('0xec4d31d9c8525f14d8e826ecd6a932dd70018c58'),
('0xe96ba9a708088995d757aceaaad93dc93af222b9'),
('0xd9ce08e64e7aba2fa3ab08e9beb9e1517fcd4a9b'),
('0xd4f48a6786a482c3994008cd7b258616dbd5b13a'),
('0xce0e505cb66dab36c93aeb75641de887bdc96e5b'),
('0xc3f6cd518b57d8c56d4c3ca3a74d3c0bf85c0787'),
('0xbb4c7c52be67bbd362f8e102b2a2536232f911e4'),
('0xb5d7e802d95f3a200f39d45caff3d587852c4c1e'),
('0xab0c741e4962f7ffcb24815b357b0b48d43ee79b'),
('0xa4bd49a0e7a136f5a957506c35f13bf044ce4529'),
('0x9e1aeb15bcbc0fb969e3e3232805d36414d0498c'),
('0x900edde7554da96cb299747f8f065a07ea1c4aa7'),
('0x62492229431daeed50866506594d6bf7076bfc45'),
('0x54def180e1b9a38f6c3f492a5a486b7e04304a05'),
('0x4f5e8b72f66c2903aa262dcb0b8a454a17a881c1'),
('0x4e6761225af2dc71bc9da2e2e95b24bcf52172d0'),
('0x25054f748295d9beb98e781c2a31a57f1620a91b'),
('0x1921881002dfe6bb776cd58adb2c83c5ada6a3b8'),
('0x0e848c75bfa28a95ee3aed6b1e56aa384c8734ad'),
('0x0c9f24795141b9972608b5e56b2e984806aad4a9')
) t(address) ),
ProjectCount as (
SELECT
SENDER_WALLET,
LISTAGG(PROJECT || ' (' || PROJECT_COUNT || ')', ', ') WITHIN GROUP (ORDER BY project) AS project_list
FROM (
SELECT
SENDER_WALLET,
PROJECT,
QueryRunArchived: QueryRun has been archived