0xtoshiGROUP#17
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
('0x1154e3dfe7c159fbe1d7dcd0097c8adb831f7aa0'),
('0x2cf756e3aa6997c772e9812db1897b8622e851e1'),
('0x09f36105f5fd3573c6e8a1f3941b85bf8fa32e99'),
('0xd6844a93555723b40155178351be55073bab9497'),
('0x793c43ea0d5076fc310184ef8783241afcca912b'),
('0x7f58037293257ee9ec7b3db9991ce006cdda90ea'),
('0x32e4bcb68af6a113c92238d8d1fabc7fca5091df'),
('0x808be0c90e51e03295cb6de0cc4eebe408842bff'),
('0x8e56c4693ec244321d29c93fabc75459ef6f2d93'),
('0x1fcba70fd1c0556340bf26b230d49c5a605e297d'),
('0xd56df348c6597bb391c4e7cce5f8e648e7b3ba72'),
('0x753f5b7ab3b48b75db22105f61b53d1cbaa77bd2'),
('0xe05cca4707a7301542905e0a4bf89c27d3181a29'),
('0xdae9939d73c300f69ba44901be4e86594d1383aa'),
('0x16adf4ceaf1207f37eca69f81968d9d95b0cdaca'),
('0xca24c068c40f04a2749e6fbc4ed441b3f97aff3f'),
('0x471435bc4b4d7ea00c3fdf8c39e16919e39cc252'),
('0x9af12d69aa87032c2578d6590ff3d55518756064'),
('0x9a214a0b49ef614de0abd7d6da5251eebfb5b45d'),
('0xbd495ca83a7de9dd5e289d48041dcc2e875f1320'),
('0xd7c92cdb52c2b6e5ae19d70fb2bffedacc82b6e2')
) 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