0xtoshi2024-06-19 02:09 PM
    Updated 2024-06-19
    With LayerzeroUsers as (
    SELECT SENDER_WALLET, COUNT(SOURCE_TRANSACTION_HASH) as countTx
    FROM external.layerzero.fact_transactions_snapshot
    GROUP BY 1
    ),
    Minimum20 as (
    SELECT
    ROW_NUMBER() OVER (
    ORDER BY SENDER_WALLET
    ) id,
    SENDER_WALLET
    FROM LayerzeroUsers
    WHERE countTx >= 20
    )

    SELECT *
    FROM Minimum20
    ORDER BY 1 ASC
    LIMIT 100000
    OFFSET 0
    QueryRunArchived: QueryRun has been archived