Tobi_1global-purple
    Updated 2024-08-24
    SELECT
    PROPOSER,
    COUNT(TX_ID) 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;