0xtoshi21930_query_2
    Updated 2024-06-07
    -- 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