ErsvanTop 5 user with most transaction made.
    Updated 2022-07-07
    SELECT SENDER, TRANSACTIONS, FEE, (FEE/TRANSACTIONS) AS AVG_FEE FROM(
    SELECT SENDER, COUNT(TX_ID) AS TRANSACTIONS, SUM(FEE) AS FEE FROM(
    SELECT BLOCK_TIMESTAMP, TX_ID, SENDER, FEE FROM flipside_prod_db.algorand.transactions WHERE BLOCK_TIMESTAMP > '2022-01-01' ORDER BY 1 DESC
    )
    WHERE FEE IS NOT NULL
    GROUP BY SENDER
    ORDER BY 2 DESC
    LIMIT 5
    )
    Run a query to Download Data