0xtoshi21930_query_2
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
›
⌄
-- forked from 21930_query @ https://flipsidecrypto.xyz/edit/queries/4bd13dc3-8a35-4947-b795-7cf13c5fd904
With Cluster as (
SELECT * FROM (VALUES
('0x411e29f2a1612cb2e8808d86ed5e1de855afa459'),
('0xf8abbd9a8b3c9c65feacac987efe5840b9ef79eb'),
('0x4584b18269c893ac754a1ec3fca166b52a898faa'),
('0x3c4a8797381c84fe5b71980b4d1d24ea6153855a'),
('0x7f62831a33333d242a463283e943b1295f40b35d'),
('0x4c42ba2ed5dacbaa850e42675db3a437b02cb0a0'),
('0x681d05ba3b9fa339b49e30c68dc46b5c566667e7'),
('0x2aee41c6405b996f129069eae8341638ff5f943a'),
('0x55ca28c045148561bb945e99a4e689d461aa45b2'),
('0x3e1581f29c335db342e2aeddd4d7c767bc008732'),
('0xbb2bb3653e79f9c9b6877bae078f0c94294b93ab'),
('0xbf4ead3d28e80135fb252abb7747588cf7eb89ef'),
('0xc93fbfacea52164cad861b7660f32ad843e6248b'),
('0x8397fdcb9986673ed59b341a7f75e861b28c2230'),
('0x7f8e49ecb45ec8a94bf4c36aefb34c27f4669b16'),
('0x0e43c88dc92ed379c106c4bc450dffb5bf90b5d3'),
('0x47347af9bfd05d45b9438ea26cf5a00be15c0965'),
('0xe2c9f28e69df44abaa705464b13b8ef11b60d064'),
('0x984d157e0165e8e367d4dff6872a5183e81fc48f')
) 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
QueryRunArchived: QueryRun has been archived