0xtoshiGROUP#28
Updated 2024-05-26
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
('0xebfcd3e0c2f8b3dd9759d1ea40df144136dcc8ce'),
('0xe491886293bad38c4daa4b7add409302740a79e3'),
('0xe342aa37b9304d17541cf61f65ca07b4fe0fa1e2'),
('0xdad0b7f4db96c469ed1948fe7e78f7af3888f149'),
('0xd95d6b144f439db4a66cb51ed2b4bc18630511e6'),
('0xab1d62340337e5c73ceccabdd4997dc7f37ae3c4'),
('0xa69a7d3d6315222e4472a96b9e37ca443d336412'),
('0x9b56d115e77436bc43d220a21c4e3feace59b9db'),
('0x8fbdbc39048c5f9d26e763287275985d3c32bec7'),
('0x866c15214ae3a5a7347987e1d71542b3ed0086be'),
('0x829ca81d5d76dd2c9c6c7bca2020edbba850bc0f'),
('0x71a93b8693db6251a7b9681db5002059b38ac564'),
('0x6279b43f7c27e898da2104248db44ccff31d9d24'),
('0x4d7c1f13692c424c12ebdb6712d28561a221175b'),
('0x1a36f4b4a9074fa328be8ce64775e14290be445f'),
('0x076ecc39615d02ccc4dba405298761ba1b87500f'),
('0x05089f2d1fcd55fa07d8f65a6bffc4e70b415749'),
('0x0052e08658dc173d7f1548a0ec8f7b3ae2b8213a')
) 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)
GROUP BY SENDER_WALLET, PROJECT
) AS subquery
QueryRunArchived: QueryRun has been archived