0xtoshi2024-06-03 08:52 AM
    Updated 2024-06-03
    WITH LZAGE as (
    SELECT SENDER_WALLET,
    COUNT(SOURCE_TRANSACTION_HASH) as txCount,
    FROM external.layerzero.fact_transactions_snapshot
    GROUP BY 1
    ),
    Counting as (
    SELECT txCount,
    COUNT(SENDER_WALLET) as total_address
    FROM LZAGE
    GROUP BY 1
    )

    SELECT
    CASE
    WHEN txCount BETWEEN 0 AND 100 THEN '0-100'
    WHEN txCount BETWEEN 101 AND 200 THEN '100-200'
    WHEN txCount BETWEEN 201 AND 300 THEN '201-300'
    WHEN txCount BETWEEN 301 AND 400 THEN '301-400'
    WHEN txCount BETWEEN 401 AND 500 THEN '401-500'
    WHEN txCount BETWEEN 501 AND 600 THEN '501-600'
    WHEN txCount BETWEEN 601 AND 700 THEN '601-700'
    WHEN txCount BETWEEN 701 AND 800 THEN '701-800'
    WHEN txCount BETWEEN 801 AND 900 THEN '801-900'
    WHEN txCount BETWEEN 901 AND 1000 THEN '901-1000'
    ELSE '>1000'
    END AS tx_range,
    SUM(total_address) AS total_address
    FROM Counting
    GROUP BY 1


    QueryRunArchived: QueryRun has been archived