0xtoshiGROUP#28
    Updated 2024-05-26
    With Cluster as (
    SELECT * FROM (VALUES
    ('0xebfcd3e0c2f8b3dd9759d1ea40df144136dcc8ce'),
    ('0xe491886293bad38c4daa4b7add409302740a79e3'),
    ('0xe342aa37b9304d17541cf61f65ca07b4fe0fa1e2'),
    ('0xdad0b7f4db96c469ed1948fe7e78f7af3888f149'),
    ('0xd95d6b144f439db4a66cb51ed2b4bc18630511e6'),
    ('0xab1d62340337e5c73ceccabdd4997dc7f37ae3c4'),
    ('0xa69a7d3d6315222e4472a96b9e37ca443d336412'),
    ('0x9b56d115e77436bc43d220a21c4e3feace59b9db'),
    ('0x8fbdbc39048c5f9d26e763287275985d3c32bec7'),
    ('0x866c15214ae3a5a7347987e1d71542b3ed0086be'),
    ('0x829ca81d5d76dd2c9c6c7bca2020edbba850bc0f'),
    ('0x71a93b8693db6251a7b9681db5002059b38ac564'),
    ('0x6279b43f7c27e898da2104248db44ccff31d9d24'),
    ('0x4d7c1f13692c424c12ebdb6712d28561a221175b'),
    ('0x1a36f4b4a9074fa328be8ce64775e14290be445f'),
    ('0x076ecc39615d02ccc4dba405298761ba1b87500f'),
    ('0x05089f2d1fcd55fa07d8f65a6bffc4e70b415749'),
    ('0x0052e08658dc173d7f1548a0ec8f7b3ae2b8213a')
    ) 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
    QueryRunArchived: QueryRun has been archived