0xtoshiGROUP#30
    Updated 2024-05-26
    With Cluster as (
    SELECT * FROM (VALUES
    ('0xe8cc9878342ae49a44473357fb035f57d0c4e0f8'),
    ('0xe202134d7f9d895d3eefb27c1a393afb7a32e22f'),
    ('0xbf78d36a9322f7b204c1bd50b1172f321f568b78'),
    ('0xb600e3563f4be341d54935ec387ec2c12b0e6adb'),
    ('0x9ef7ceb424e2cf05996b33c5e3426ec459236a3e'),
    ('0x8ebb6ad75a3e6401cac81263dd4fb0772bac2e7b'),
    ('0x7748147437490b24970d787958dc39cd3806d6ac'),
    ('0x67ee974245df3af109ef65e0cf0d4f3caf05a184'),
    ('0x5c7f75b322467d41d6042934bd48f4b47567e47b'),
    ('0x4931d28f0e29d5ab30e38738a0ab5e145844d573'),
    ('0x44c19dc0c96c819774e05b8804328f937c28152f'),
    ('0x401d527cfc16a8e07b33f8a106052a17f98350a6'),
    ('0x2b91935da0ce8afd25a61760e04c6bc2f968da26'),
    ('0x2105a5eb1a3aa04b06b323d1881a7ba11952337c'),
    ('0x16a896395712747ee507d7b6eed1d7a605429b76'),
    ('0x0f042d80dcdf12eead83dea46ea021413fc48205'),
    ('0x0022a3e9e71aaa6b7c8ebc16cc35f22ac64c9b58')
    ) 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)
    GROUP BY SENDER_WALLET, PROJECT
    ) AS subquery
    GROUP BY SENDER_WALLET;
    QueryRunArchived: QueryRun has been archived