0xtoshiGROUP#16
    Updated 2024-05-26
    With Cluster as (
    SELECT * FROM (VALUES
    ('0x8fb9be046a0e1d7a7069586a4706e93e39fe5f34'),
    ('0x1981fee2f81f1dd323e023b119db124dabea396e'),
    ('0x4f641d6afc45e5de976d91f3ee0c5fce7ce7e11f'),
    ('0x01362d5923530672d6a887ccdfc8b156cee97824'),
    ('0xda12b49d10329520be0ee0fb4084e882b786766f'),
    ('0x99436be04157c939f548abd8e3cae9ce01c7abca'),
    ('0xc4d18fc7d98f204e393a3045ee9073e87c137e8b'),
    ('0x0f93149d54461a783c1517b23974113b89e38241'),
    ('0xeb29cbf4b3d04e003b3c82fbbf45f0c97cab3451'),
    ('0x123317f544d620465d938789656edfcf9699330f'),
    ('0x1e1e723fd7d851fc66f47cc4fe2de209d55f4465'),
    ('0x1171697a3f96a3790e6c265fd1d9f0c601f08f79'),
    ('0x1946e3e87e3d112d05b28c12b831d03f492d14c3'),
    ('0xa2cf1a1a6ff5b38889065c41963306a0940f3a4f'),
    ('0x0700efd158f49f0958d85cdb0b28e1f24fdfb7db'),
    ('0x5d4d36ced9a3096fb1916fc83675bc3785afc971'),
    ('0x30d3f805c896d8b6290d7978d7121ff24ce4ab22'),
    ('0xe6bd578dc88b5b867f2b8e0bd91f9cc120f8a07f'),
    ('0x2b07bcf9a00da1f739ef112c11947dfbb452a7ef'),
    ('0x466f0ac408d52e7eb082aca07f2835a0d5b8d89b'),
    ('0x98e640296317a9f5ab7078ebeb7e685da030a19a')
    ) 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