WITH wallets AS (
SELECT
SUM (FEE) AS Fees,
SENDER
FROM flipside_prod_db.algorand.transactions
WHERE BLOCK_TIMESTAMP BETWEEN '2022-01-01' AND CURRENT_DATE
GROUP BY SENDER
HAVING Fees IS NOT NULL
ORDER BY Fees DESC
LIMIT 10
),
labels AS (
SELECT
ADDRESS,
LABEL_TYPE,
LABEL_SUBTYPE,
LABEL,
ADDRESS_NAME
FROM flipside_prod_db.algorand.labels
),
AppID AS (
SELECT
ADDRESS,
APP_ID
FROM flipside_prod_db.algorand.account_app
)
SELECT
wallets.SENDER,
wallets.Fees,
AppID.APP_ID,
labels.LABEL_TYPE,
labels.LABEL_SUBTYPE,
labels.LABEL,