WITH wallets AS (
SELECT
COUNT (TX_ID) AS Transactions,
SENDER
FROM flipside_prod_db.algorand.transactions
WHERE BLOCK_TIMESTAMP BETWEEN '2022-01-01' AND CURRENT_DATE
GROUP BY SENDER
HAVING Transactions IS NOT NULL
ORDER BY Transactions 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.Transactions,
AppID.APP_ID,
labels.LABEL_TYPE,
labels.LABEL_SUBTYPE,
labels.LABEL,