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
)