0xtoshiGROUP#27
Updated 2024-05-26Copy Reference Fork
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
('0xfb107ef723793fd617519735daf4ddb49f8561c3'),
('0xf918c679fae9e6dafa3d29a62e28f36f1661d279'),
('0xf55f8884203632eb007f239758d1b25cd173458b'),
('0xf06f09c65635ea3db2f6255cabefcc11d28f2ef2'),
('0xdc09eb652d4568c3e22d176bce8f5efb12af7716'),
('0xda6c2d0f44352d9f4b8ebb00606657310ea4e26b'),
('0xc062eeca3891539f75054b1060997aa3459b7390'),
('0xc03f8455f1492a1598b43211b0573b67ecc58c62'),
('0xbbfc1d1f420703aebe13007f5ce0182f70bf35b9'),
('0x8d2a309db3176423569856c245e13cfc6baa53c8'),
('0x76363226b9e31b78c2077ecea78f440d81299f39'),
('0x70ae7ed8469e55a82497816001644ac123513a18'),
('0x7097427db99b7d3535caec5970da74cd6043af04'),
('0x562bf1b67dc40d9b7c3ddd49e45ae58e61e1b76e'),
('0x4e229156470863b00bb6c03a78797632921be81d'),
('0x40276ba5efdfbbf749557f6b2a094abd78197164'),
('0x2fc5fe33b36f75219beb038db84049ffa74dc036'),
('0x1b20ea8afd7f82fac122683d00e6b598064941b3'),
('0x184f44a581a3fdf67e834cf2a0f193cbdd08a3b9'),
('0x1765a1b1cf3f083edc084e72301caa51f89e4028'),
('0x0bc4ecc2a47413af3552be58bf741fcb04f13bcd'),
('0x07eb5c84daaa840a3fee3896f28111ef42c5792e')
) 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
QueryRunArchived: QueryRun has been archived