0xtoshi2024-05-29 01:23 AM
    Updated 2024-05-28
    With OmniCat as (
    SELECT SENDER_WALLET, COUNT(SENDER_WALLET) as txsCount
    FROM external.layerzero.fact_transactions_snapshot
    WHERE PROJECT = 'Aptos Bridge'
    AND LENGTH(SENDER_WALLET) = 65;
    GROUP BY 1
    )

    SELECT * FROM OmniCat
    WHERE txsCount BETWEEN 100 AND 120
    QueryRunArchived: QueryRun has been archived