0xtoshi18848_group2
    Updated 2024-06-07
    With Cluster as (
    SELECT * FROM (VALUES
    ('0x37bddbb15a22b4f01274ed8b1d3309eee7e7b86a'),
    ('0x426f61366bf4bd92cbfc39668a0c4e00ed276e95'),
    ('0x4660c065e7f473c460812a9f516611165cd78c86'),
    ('0x96d2db077bc2b63628cbc8496cc2b1c0d06c0888'),
    ('0xe20fb13ef942161d4b4d89c00a77d957a2bcb37a'),
    ('0x2792ca5dca91fc6da6d0ddce5ae287190353cd0a'),
    ('0x3fd061011bf25d6bd66d251526338abf58a98ba3'),
    ('0x493e48897aebc587464547e63e9f1da53c905015'),
    ('0x6b61d218e1e1d3e0d3bfc1bfcb73ddc727af8b25'),
    ('0x8512a48013b2c96afe3ee77b166f8a1026df50bd'),
    ('0x8fbba94316428465b54f9d21484c88d2dd2e7728'),
    ('0xb7f118529439b099fa5c0ba9dfc37c25d9629769'),
    ('0xc1016d7f5879cfea0719255314ff3730575c7814'),
    ('0xd1d9e7df60e5a01b23ba23b374d5b1cd1fd4fdad'),
    ('0xd792f79a793026a544f5927f83c906679d09e41a'),
    ('0xdb439b6cc2259b82702eaeb53b89f7ea540fd704'),
    ('0xdc7673007be60d2dc320bff3d982412848fa9579'),
    ('0xe61729b474a30ab4a0f3eda8679e092fb646fd06'),
    ('0xb879996c1f33039017a0626ab93b885c2b03d7db'),
    ('0xa27c1a0dd595210ce22d3ba898d7fd87bfcc993c')
    ) 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
    AND SENDER_WALLET IN (SELECT address FROM Cluster)
    QueryRunArchived: QueryRun has been archived