0xtoshiGROUP#27
    Updated 2024-05-26
    With Cluster as (
    SELECT * FROM (VALUES
    ('0xfb107ef723793fd617519735daf4ddb49f8561c3'),
    ('0xf918c679fae9e6dafa3d29a62e28f36f1661d279'),
    ('0xf55f8884203632eb007f239758d1b25cd173458b'),
    ('0xf06f09c65635ea3db2f6255cabefcc11d28f2ef2'),
    ('0xdc09eb652d4568c3e22d176bce8f5efb12af7716'),
    ('0xda6c2d0f44352d9f4b8ebb00606657310ea4e26b'),
    ('0xc062eeca3891539f75054b1060997aa3459b7390'),
    ('0xc03f8455f1492a1598b43211b0573b67ecc58c62'),
    ('0xbbfc1d1f420703aebe13007f5ce0182f70bf35b9'),
    ('0x8d2a309db3176423569856c245e13cfc6baa53c8'),
    ('0x76363226b9e31b78c2077ecea78f440d81299f39'),
    ('0x70ae7ed8469e55a82497816001644ac123513a18'),
    ('0x7097427db99b7d3535caec5970da74cd6043af04'),
    ('0x562bf1b67dc40d9b7c3ddd49e45ae58e61e1b76e'),
    ('0x4e229156470863b00bb6c03a78797632921be81d'),
    ('0x40276ba5efdfbbf749557f6b2a094abd78197164'),
    ('0x2fc5fe33b36f75219beb038db84049ffa74dc036'),
    ('0x1b20ea8afd7f82fac122683d00e6b598064941b3'),
    ('0x184f44a581a3fdf67e834cf2a0f193cbdd08a3b9'),
    ('0x1765a1b1cf3f083edc084e72301caa51f89e4028'),
    ('0x0bc4ecc2a47413af3552be58bf741fcb04f13bcd'),
    ('0x07eb5c84daaa840a3fee3896f28111ef42c5792e')
    ) 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