0xtoshi18848_group2
Updated 2024-06-07
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
('0x37bddbb15a22b4f01274ed8b1d3309eee7e7b86a'),
('0x426f61366bf4bd92cbfc39668a0c4e00ed276e95'),
('0x4660c065e7f473c460812a9f516611165cd78c86'),
('0x96d2db077bc2b63628cbc8496cc2b1c0d06c0888'),
('0xe20fb13ef942161d4b4d89c00a77d957a2bcb37a'),
('0x2792ca5dca91fc6da6d0ddce5ae287190353cd0a'),
('0x3fd061011bf25d6bd66d251526338abf58a98ba3'),
('0x493e48897aebc587464547e63e9f1da53c905015'),
('0x6b61d218e1e1d3e0d3bfc1bfcb73ddc727af8b25'),
('0x8512a48013b2c96afe3ee77b166f8a1026df50bd'),
('0x8fbba94316428465b54f9d21484c88d2dd2e7728'),
('0xb7f118529439b099fa5c0ba9dfc37c25d9629769'),
('0xc1016d7f5879cfea0719255314ff3730575c7814'),
('0xd1d9e7df60e5a01b23ba23b374d5b1cd1fd4fdad'),
('0xd792f79a793026a544f5927f83c906679d09e41a'),
('0xdb439b6cc2259b82702eaeb53b89f7ea540fd704'),
('0xdc7673007be60d2dc320bff3d982412848fa9579'),
('0xe61729b474a30ab4a0f3eda8679e092fb646fd06'),
('0xb879996c1f33039017a0626ab93b885c2b03d7db'),
('0xa27c1a0dd595210ce22d3ba898d7fd87bfcc993c')
) 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
WHERE PROJECT IS NOT NULL
AND SENDER_WALLET IN (SELECT address FROM Cluster)
QueryRunArchived: QueryRun has been archived