0xtoshiGROUP#22 copy
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
›
⌄
-- forked from GROUP#22 @ https://flipsidecrypto.xyz/edit/queries/91a2c88b-9176-4d89-8c15-5b418ba9e349
With Cluster as (
SELECT * FROM (VALUES
('0x62a7568aaf448ac607bbaa5db70d84bef0f57beb'),
('0x13adf7fa36560bb70c18c1cc1b51db46a7143bc5'),
('0xb9e54bbc68c48baf4695d252fc53782bb790f767'),
('0xac4512c04cd05d9b1cd36d96d20893f57ba1932e'),
('0xe51dde4a2f92cd612cc43370fd43fb152114fc18'),
('0xcb56a950cefb5180f0d0129fd65f9c342bd9492b'),
('0x9046f536871e793dc7635315332c531ece44e4c5'),
('0x659aa1c506b7bfd8302a8acf9e7c4c82c3ee40e0'),
('0x82462d164a33262b2d564f6f6a3551f5ba14b789'),
('0x655a4403d0ad99177ee1dbeb8f9c514135bef396'),
('0x561c32bd1903a7bd2a065a08b1a737ba72cf9089'),
('0x51b01e2490347d76c4e986b1d5fe6a4b619662a8'),
('0x283a3eeff6a547c59ca5c763556070ead2582383'),
('0x22c58a94bf0b2946296d799789b3a0962922994a'),
('0x2286e3858ed539f8b1605ab52a5fc2e263d50a2a'),
('0x1d6e011dee5095f47cb7abda02ff545300a0da5f'),
('0x10b226ddad05bd2c8e42ef4d65a5d2bace6640ac'),
('0x0f2fbce21bb35206b9ddadcbb589dadf78bc323b'),
('0x9b9daaeb98854ac6e71801e3b22eac5bf146214f'),
('0x6794850ddd16275eb6988356fc9cdc8a81c5dca7'),
('0x4acbce47b3afb69e0627edc95c71858a96c86f55'),
('0x4775e8f8d83283c7fd64de9be19781f42ff185d8'),
('0x49950899b7e6f860d57e2aef2265f7b762127e8f'),
('0x246b6219f45d003ef6cf477d8abe15a93127b633'),
('0x23fd12b65f4237bd645586a24065eff35d82034c')
) t(address) ),
ProjectCount as (
SELECT
SENDER_WALLET,
LISTAGG(PROJECT || ' (' || PROJECT_COUNT || ')', ', ') WITHIN GROUP (ORDER BY project) AS project_list
FROM (
Run a query to Download Data