0xtoshiGROUP#30
Updated 2024-05-26
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
›
⌄
With Cluster as (
SELECT * FROM (VALUES
('0xe8cc9878342ae49a44473357fb035f57d0c4e0f8'),
('0xe202134d7f9d895d3eefb27c1a393afb7a32e22f'),
('0xbf78d36a9322f7b204c1bd50b1172f321f568b78'),
('0xb600e3563f4be341d54935ec387ec2c12b0e6adb'),
('0x9ef7ceb424e2cf05996b33c5e3426ec459236a3e'),
('0x8ebb6ad75a3e6401cac81263dd4fb0772bac2e7b'),
('0x7748147437490b24970d787958dc39cd3806d6ac'),
('0x67ee974245df3af109ef65e0cf0d4f3caf05a184'),
('0x5c7f75b322467d41d6042934bd48f4b47567e47b'),
('0x4931d28f0e29d5ab30e38738a0ab5e145844d573'),
('0x44c19dc0c96c819774e05b8804328f937c28152f'),
('0x401d527cfc16a8e07b33f8a106052a17f98350a6'),
('0x2b91935da0ce8afd25a61760e04c6bc2f968da26'),
('0x2105a5eb1a3aa04b06b323d1881a7ba11952337c'),
('0x16a896395712747ee507d7b6eed1d7a605429b76'),
('0x0f042d80dcdf12eead83dea46ea021413fc48205'),
('0x0022a3e9e71aaa6b7c8ebc16cc35f22ac64c9b58')
) 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
GROUP BY SENDER_WALLET;
QueryRunArchived: QueryRun has been archived