0xtoshiGROUP#17
    Updated 2024-05-26
    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