Tobi_1male-lime
    Updated 2024-09-09
    SELECT
    PROPOSER,
    COUNT(*) AS total_transactions
    FROM
    flow.core.fact_transactions;
    WHERE
    BLOCK_TIMESTAMP >= DATEADD(DAY, -30, CURRENT_TIMESTAMP())
    GROUP BY
    PROPOSER
    ORDER BY
    total_transactions DESC
    LIMIT 10;

    QueryRunArchived: QueryRun has been archived