0xtoshiGROUP#14
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
('0xb7cd56f319f2f1ee2298ae7e5b23b2507a89b95b'),
('0x22b376d7a781d00ac6c0db5db5ca6d85029e1dca'),
('0x5de79de0536128daef8323104278c345e491b781'),
('0xde5cb874e32b5011a82b4f8fe7a768255d0edeae'),
('0x323a700e62e05a94ce015cb34d4f27869876bcb8'),
('0x493b27a57b897b811af56b7f67710c0479a13f42'),
('0x4e3eb649e9d2b7a7effdff203468d9bcb04d8653'),
('0x779c29a3ca3c1b28f557d4712cbe74da41d1a52b'),
('0x071ba7ec7e39bd7c5d115a6bd881408786831be0'),
('0x55d4ffa3291911bee9b5c3d09a9b288e567b1670'),
('0x27c1e803631182ed8801a617199847534c4119d2'),
('0x328915d7a445639e035ab46ca718a095d708ebe7'),
('0x1bc56e88063f9c1108bd2d3ea7f3ae1a0a6d1380'),
('0xd0bc4f8c6757da0e9ef06a875fe6ee3824ce77ca'),
('0x4b925e27a1b54f11982477d7067f131cdcba3b42'),
('0x79ce7dea3839d7eb583af0f042c260aee90961ba'),
('0xa8b6a4bb6130e12755968c552efe97206a99ddbd'),
('0xf723dd537367fd7ac79b60529f6b31b826b914e9'),
('0xc17abbab517a4d72b62a7edb15ef62b8025c38c8'),
('0x3dcefd0f55064cd9ae72417f755991675e3b6123'),
('0xb107ac8f58f367bacb17791f65fe825e3e5b23e1'),
('0x72c1633673a76f0647e7280d250dba0d5e59f6a8'),
('0x93ec2db111666c277aafc5e7364ff20ed66cf979'),
('0xbc13cc6a10a2603d3a4e7719ec4a807b2f477b0a'),
('0x0033844f0e356b89d96e74acd502d83a2e42d0f6')
) t(address) ),
ProjectCount as (
SELECT
SENDER_WALLET,
LISTAGG(PROJECT || ' (' || PROJECT_COUNT || ')', ', ') WITHIN GROUP (ORDER BY project) AS project_list
FROM (
SELECT
QueryRunArchived: QueryRun has been archived