0xtoshigroup#5
    Updated 2024-05-28
    With Cluster as (
    SELECT * FROM (VALUES
    ('0xf1971d6d63cae2bb6aeacbacb7aa676c0c834ca2'),
    ('0xf1094c78ae812ef0c37f55f20448a3ee32a8748f'),
    ('0xc68988d2042b98e647121cd7b7fe31ae92edd6b9'),
    ('0xbb8846a98a1867efe0fb126b9add661bccfed0cc'),
    ('0xb999b17976e0187d1b7d7bf4bdbc849f015e1dde'),
    ('0xb04130bc7a61084bf4023275e774aa126126ede8'),
    ('0xa39862542e29f93cff498147ee6c5310ae488486'),
    ('0xa1c64be9dae6eab20ee677d94ebbd94f66649375'),
    ('0x9077557aee71f204cb25151407969628d8e15979'),
    ('0x88e70e87e9565af9d88b5377179ec0104117fd6e'),
    ('0x877720f5c1e726eb86ee80bb19aac356b9b1895a'),
    ('0x7c954d23bf8505f37c7587ffeee7cde07f509261'),
    ('0x741c5fce3757f6be5907435fc000971e71f7d74a'),
    ('0x737f83006825d994eae1cb709e8ec269c471f8e3'),
    ('0x7028331f972bf2dd3582420c7c2400515d079a9a'),
    ('0x51785ab9d0068d55f5f9ae1603f94f70915fca4e'),
    ('0x4dba3976ba12a03019d10db3443b2ea3551cd4db'),
    ('0x42f208531dcc5f9f9bce7ed4d56ebbc730938505'),
    ('0x3ffedf1112b6da920fc40cfbd4a60c653ec0da24'),
    ('0x3baa092f023bdefde8b1df0a438073eb27eba4cb'),
    ('0x214dbfa1012690eb0b5f042dc37dab86a2e5ebd0'),
    ('0x19472843093974a855b7c703f8379b3f5b467daf')
    ) 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
    QueryRunArchived: QueryRun has been archived