0xtoshicountAge
    Updated 2024-06-03
    WITH LZAGE as (
    SELECT SENDER_WALLET,
    DATEDIFF('day', min(SOURCE_TIMESTAMP_UTC), '2024-05-01 23:59:59') as age
    FROM external.layerzero.fact_transactions_snapshot
    GROUP BY 1
    ),
    Counting as (
    SELECT age,
    COUNT(SENDER_WALLET) as total_address
    FROM LZAGE
    GROUP BY 1
    )

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


    QueryRunArchived: QueryRun has been archived