0xtoshicluster3
Updated 2024-06-06
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
('0xc4330903734e3a3bcc2dc34ffef2b31c3424afac'),
('0x75f56ee03d1e0b661cbb0f6ed594b973c33a4367'),
('0x83e5d5b8c348630781d985890c5909292235087d'),
('0x2c72165cc6add29877dda8ea4294764764c0feac'),
('0x6c83faf34981c1c7e7336ec76a0df64ada4e5567'),
('0xe1c5c3ffa6d4bd7b46922c7c75240546c9d31899'),
('0xd2698ad670a2f1aed6372021262225ee3e8bb2f4'),
('0xd3bbd2d6cea016aa79e23fd929373a6f652d744b'),
('0xd9f0641fb2e0e2683e63a0d3d8a5eadf4bfb0c73'),
('0xb2b83d8ff655efd956214884c6ae084c20d9ea89'),
('0x3facf2dde2515a1c53ed076f453b3835c1fbd55e'),
('0x967302b59b965998acb92e81f464a8a4b067a994'),
('0x1d6a71604879fc00062bb23e77a9165cbbbb49d0'),
('0x7eda733fae6747e601d561957f8512b354065865'),
('0x3c90f313ca46a88b57e54da9014d6aaa8f4a5e01'),
('0xe80b6e4e0a935f97dd530dace895d07f012eadeb'),
('0x6b22d7e1f5a494c7640ab806736a77fe1853b389'),
('0x9ca24897ad793609e137f19c600fc37fe5964d4b'),
('0x79e7de9d3d1aac46a12ed1a45f4bbcc4bc2e92ae'),
('0x80e9c6217a155ccf1dc25da3c6a2a19250a45ead'),
('0xbed9bff7fe17f740db5e4dcc098ed56dbfdea673'),
('0x6b7eb241a0d0637009c75c8213e3f67a01a00b3f'),
('0x8a9620f9f616860d62b18adedb11dfa46343200d'),
('0x5fba53bad487d3808d5946a13f55c6598b059c15'),
('0xd047bea147d680b4fdb5acf6e69ecd249826fdcb')
) t(address) ),
ProjectCount as (
SELECT
SENDER_WALLET,
LISTAGG(PROJECT || ' (' || PROJECT_COUNT || ')', ', ') WITHIN GROUP (ORDER BY project) AS project_list
FROM (
SELECT
SENDER_WALLET,
QueryRunArchived: QueryRun has been archived